Hi - I have a table definition similar to below. I would like to do a wildcard search on the Array column. What is the best approach for this?
create table A (col1 uuid, col2 uuid, col3 STRING, constraint pk_A Primary key (col1, col2))
I want to get distinct of col2. my filters are on col1 and the wildcard on col3 can only be applied right now after unnesting(according to the docs). wonder if it is possible at all to perform wildcard without unnesting. If that is the only way, what are my other alternatives as the query performance is not great with unnesting in subquery and then applying wildcard filter