Hive/Impala translator - select distinct and gorup by is not supported in one query ----------------------------------------------------------------------------------- Key: TEIID-4158 URL: https://issues.jboss.org/browse/TEIID-4158 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 8.12.x Reporter: Juraj Duráni Assignee: Steven Hawkins Fix For: 9.0, 8.12.5 Hive and Impala do not support combination of SELECT DISTINCT and GROUP BY in one SQL query. Messages of exceptions: Impala - cannot combine SELECT DISTINCT with aggregate functions or GROUP BY Hive - SELECT DISTINCT and GROUP BY can not be in the same query. DDL: {code:sql} CREATE VIEW Agg2 (StringNum string) AS SELECT BQT1.SmallA.StringNum FROM BQT1.SmallA GROUP BY BQT1.SmallA.StringNum HAVING BQT1.SmallA.StringNum = '1'; {code} Query: {code:sql} SELECT DISTINCT StringNum FROM VQT.Agg2 {code}