Hi team, does a text index enabled col support

IN

and

NOT IN

operation? The doc mentions it doesn’t co-exist with other indexes so wonder if this operation is supported and if it is performant.

Hi Zhuangda, can you provide the link to the doc you're referring to? Thanks

I have not heard of any limitations with these operators. Pinot uses the Calcite SQL parser which supports IN and NOT IN. I would suggest to try it. https://docs.pinot.apache.org/users/user-guide-query/querying-pinot#sql-interface

Yeah definitely. was mainly curious how it performs comparing to inverted index.