[teiid-issues] [JBoss JIRA] (TEIID-4158) Hive/Impala translator - select distinct and gorup by is not supported in one query
RH Bugzilla Integration (JIRA)
issues at jboss.org
Wed May 4 20:03:01 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13201229#comment-13201229 ]
RH Bugzilla Integration commented on TEIID-4158:
------------------------------------------------
Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1329169|https://bugzilla.redhat.com/show_bug.cgi?id=1329169] from MODIFIED to ON_QA
> 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}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list