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.