Re: [I] [Regression] Non Agg Group By queries work in 0.11 but fail in 0.12 [pinot]

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

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: 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