Hello! I am using Presto Pinot python connector to query Pinot. I have a requirement for a regex type predicate on one of the dimensions. I created text index on the dimension. Will this help in the performance? Will it be able to use TEXT_MATCH to query?
m
Mayank
06/24/2021, 1:17 AM
You can explain the presto query that should tell the Pinot query. You can check if it is using text match.
s
Sheetal
06/24/2021, 1:20 AM
ohh, sorry if this seems dumb, I am new to Presto-Pinot. I did try the explain<query> but the output does not speify any query plan details. How to check it?
x
Xiang Fu
06/24/2021, 8:23 AM
then it’s not using Pinot push down
Xiang Fu
06/24/2021, 8:23 AM
In general the solution is to add the support for regex push down