miklosgergely opened a new pull request #544: HIVE-16924 Support distinct in presence of Group By URL: https://github.com/apache/hive/pull/544 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'
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
