[
https://issues.apache.org/jira/browse/HIVE-16648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anshuman reassigned HIVE-16648:
-------------------------------
Assignee: Anshuman
> Allow select distinct with group by
> -----------------------------------
>
> Key: HIVE-16648
> URL: https://issues.apache.org/jira/browse/HIVE-16648
> Project: Hive
> Issue Type: Sub-task
> Components: SQL
> Reporter: Carter Shanklin
> Assignee: Anshuman
>
> Although there are very few legitimate reasons to have both "select distinct"
> and "group by" in the same query, it is still used from time to time and
> other systems support it.
> Illustrating the issue:
> {code}
> hive> create table test (c1 integer);
> OK
> Time taken: 0.073 seconds
> hive> select distinct c1 from test group by c1;
> FAILED: SemanticException 1:38 SELECT DISTINCT and GROUP BY can not be in the
> same query. Error encountered near token 'c1'
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
