Bug 1379351

Summary:	Google translator throws exception invalid_query for GROUP BY
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Lucie Fabrikova <lfabriko>
Component:	Teiid	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED UPSTREAM	QA Contact:	Filip Elias <felias>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	6.3.0	CC:	aszczucz, blafond, drieden, jolee, mbaluch, thauser, vhalbert
Target Milestone:	---	Keywords:	Documentation
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-03-30 15:11:56 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:
Embargoed:

Description Lucie Fabrikova 2016-09-26 12:44:20 UTC

Description of problem:
Google translator produces following exception for a query: "SELECT IntKey FROM bqt1.SmallA GROUP BY IntKey":
16:27:26,955 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) TEIID30019 Unexpected exception for request vn+N1XY8Atf5.6: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: [invalid_query]
at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDataProtocolAPI.java:196)
... 

Version-Release number of selected component (if applicable):


How reproducible:
always

Steps to Reproduce: - Please see attached JIRA TEIID-4467
1. 
2.
3.

Actual results:


Expected results:


Additional info: