[GitHub] [arrow-datafusion] comphead commented on issue #6586: Why is this group by statement inconsistent with what I expected

["comphead (via GitHub)" <gi...@apache.org>]

comphead commented on issue #6586:
URL: https://github.com/apache/arrow-datafusion/issues/6586#issuecomment-1581698361

   HI @web3creator 
   your query
   ```
               "SELECT c1,c2 from aggregate_test_100  GROUP BY c1,c2",
   ```
   groups by both c1, c2. in this case you will get all unique combinations for c1 and c2. if you want to group C1 only
   you will have to `GROUP BY c1,` and some aggr function on C2 like
   
   ```
               "SELECT c1,sum(c2) from aggregate_test_100  GROUP BY c1",
   ```


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org