Jackie-Jiang commented on issue #11866: URL: https://github.com/apache/pinot/issues/11866#issuecomment-1789314152
@ankitsultana It is a valid query, and the example you posted shows the problem of the original re-write. In Pinot, if we rewrite it into `select distinct concat(id, nm, '-') from testing_groupby`, it will return a single row instead of 2 rows from PostgreSQL (standard SQL) @heydoriszhang You may take a look at the example @ankitsultana posted. I don't want to revert #9605 because it is the wrong and unsafe behavior. Multi-stage engine is giving the correct SQL behavior, not the old single-stage behavior. In order to fix this, we should follow the SQL behavior and directly support group-by without aggregation in single-stage engine -- 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]
