[teiid-issues] [JBoss JIRA] (TEIID-4158) Hive/Impala translator - select distinct and gorup by is not supported in one query
Juraj Duráni (JIRA)
issues at jboss.org
Thu Apr 21 05:17:01 EDT 2016
Juraj Duráni created TEIID-4158:
-----------------------------------
Summary: 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
Affects Versions: 8.12.x
Reporter: Juraj Duráni
Assignee: Steven Hawkins
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}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list