Hi Folks, is there a direct way( or a query) to check if a subset of values exist in a pinot multi value column without checking each element separately? eg. select * from a where test_tags in (‘a’, ‘b’) I want both (‘a’,‘b’) to exist in the column. test_tags can contain more values as well but, (‘a’, ‘b’) should be a subset.

I would use a conjunction:

WHERE test_tags = a and test_tags = b