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-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
