[HIVE-16924] Support distinct in presence of Group By

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Query Planning
• Labels: pull-request-available
• Assignee: Miklos Gergely
• Reporter: Carter Shanklin
• Created: 20/Jun/17 22:39
• Updated: 27/Feb/24 22:23
• Resolved: 16/Mar/19 15:51

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'

Issue Links

• is duplicated by: HIVE-16648 Allow select distinct with group by
• links to: GitHub Pull Request #544