Bug 1329169

Summary: Hive/Impala translator - select distinct and gorup by is not supported in one query
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Juraj Duráni <jdurani>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact: Juraj Duráni <jdurani>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.3.0CC: aszczucz, blafond, jolee, jstastny, mbaluch, thauser, vhalbert
Target Milestone: ER3   
Target Release: 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-08-24 11:39:18 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Juraj Duráni 2016-04-21 10:19:33 UTC 
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:
CREATE VIEW Agg2 (StringNum string)
  AS SELECT BQT1.SmallA.StringNum FROM BQT1.SmallA GROUP BY BQT1.SmallA.StringNum HAVING BQT1.SmallA.StringNum = '1';
Query:
SELECT DISTINCT StringNum FROM VQT.Agg2
Comment 2 JBoss JIRA Server 2016-04-21 15:52:52 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-4158 to Resolved
Comment 3 JBoss JIRA Server 2016-06-08 12:00:44 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-4158 to Closed