group by does not work with sort by/cluster by/distribute by etc.
-----------------------------------------------------------------

                 Key: HIVE-614
                 URL: https://issues.apache.org/jira/browse/HIVE-614
             Project: Hadoop Hive
          Issue Type: Bug
          Components: Query Processor
            Reporter: Namit Jain


Say there is a table: T (a,b,c)

the following query:


select a, count(c) from T group by a sort by b;


does not work:

The sorting/clustering columns have to be a subset of grouping columns.


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to