tarun11Mavani commented on PR #15756:
URL: https://github.com/apache/pinot/pull/15756#issuecomment-2869188043

   > Which AND among the two are you referring to?
   > 
   > > **What type of queries are impacted?** When we have a query of type `AND 
(condition1 OR condition2) AND REGEXP_LIKE`, the AND predicate evaluates to 
BlockDocIdIterator and Pinot scans through all docs due to evaluate REGEXP_LIKE 
predicate instead of running predicate only on filtered doc from AND condition. 
This causes very high doc
   
   Actually the query should be like `(column1='abc' OR column2='xyz') AND 
REGEXP_LIKE`. I have corrected the [PR 
summary](https://github.com/apache/pinot/pull/15756#issuecomment-2869182301)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to