Hello! I am using Presto Pinot python connector to...
# troubleshooting
s
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
You can explain the presto query that should tell the Pinot query. You can check if it is using text match.
s
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
then it’s not using Pinot push down
In general the solution is to add the support for regex push down
👍 1