[ 
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.

Reply via email to