Details
-
New Feature
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
Description
create table e011_01 (c1 int, c2 smallint); insert into e011_01 values (1, 1), (2, 2);
These queries should work:
select distinct c1, count(*) from e011_01 group by c1; select distinct c1, avg(c2) from e011_01 group by c1;
Currently, you get :
FAILED: SemanticException 1:52 SELECT DISTINCT and GROUP BY can not be in the same query. Error encountered near token 'c1'
Attachments
Attachments
Issue Links
- is duplicated by
-
HIVE-16648 Allow select distinct with group by
- Open
- links to