hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carter Shanklin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-16648) Allow select distinct with group by
Date Thu, 11 May 2017 14:29:10 GMT
Carter Shanklin created HIVE-16648:
--------------------------------------

             Summary: Allow select distinct with group by
                 Key: HIVE-16648
                 URL: https://issues.apache.org/jira/browse/HIVE-16648
             Project: Hive
          Issue Type: Sub-task
            Reporter: Carter Shanklin


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)

Mime
View raw message