mayankshriv opened a new issue #7691: URL: https://github.com/apache/pinot/issues/7691
We are seeing various cases where auto generated SQL from visualization tools perform a lot of transforms/filtering using `CASE WHEN` from within aggregation functions. However, if the original predicate in the `where clause` had low selectivity, we end up scanning a lot of data to perform the `CaseTransform` evaluation. It would be good to see if we can utilize available indexes (when possible) for evaluating these as well. -- 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
