[
https://issues.apache.org/jira/browse/HIVE-16648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16059504#comment-16059504
]
Carter Shanklin commented on HIVE-16648:
----------------------------------------
To clarify I wasn't looking for a workaround but this case does come up when
porting SQL from other DBs to Hive, most mature SQL engines are smart enough to
ignore the distinct clause in this case.
Looks like HIVE-16924 is going to tackle the more complex case when aggregates
are also present but that should cover this one as well.
> 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.4.14#64029)
