Re: [I] Performance Degradation in Queries with DateTime Field Filtering [pinot]

["Jackie-Jiang (via GitHub)" <gi...@apache.org>]

Jackie-Jiang commented on issue #12060:
URL: https://github.com/apache/pinot/issues/12060#issuecomment-1839248221

   If I read correctly, these 2 queries are not equivalent. With `OR` in the first query after the time filter, there is no way for the engine to prune the segment based on the time.
   `numDocsScanned` reflects how many records matching the filter. If you see them different in 2 queries, that means the 2 queries are not equivalent. To optimize this query, you may add range filter to `timestamp` and inverted index on `status` and `stage`. 


-- 
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: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org