Jackie-Jiang commented on issue #13000: URL: https://github.com/apache/pinot/issues/13000#issuecomment-2080214884
This is not a regression. Single stage engine doesn't support GROUP-BY without AGGREGATE, so it will rewrite `select OS_Version from CleanLogisticData GROUP BY OS_Version` into `select distinct OS_Version from CleanLogisticData`. The proper fix should be automatically adding the aggregation in the `HAVING` clause into the `SELECT`, but not show it in the final result. I don't think we have the primitive to do this right now. The query rewrite can be added, but this extra column will also be in the final result. @cyrilou242 Is this a blocker for you? -- 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
