[
https://issues.apache.org/jira/browse/HIVE-614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12728361#action_12728361
]
Namit Jain commented on HIVE-614:
---------------------------------
The above query does not make much sense - but it should lead to a graceful
error instead of a null pointer exception
> 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.