Bug 1379351 - Google translator throws exception invalid_query for GROUP BY
Summary: Google translator throws exception invalid_query for GROUP BY
Keywords:
Status: CLOSED UPSTREAM
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.3.0
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ---
: ---
Assignee: Van Halbert
QA Contact: Filip Elias
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-09-26 12:44 UTC by Lucie Fabrikova
Modified: 2017-03-30 15:11 UTC (History)
7 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-03-30 15:11:56 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker JDV7-71 0 Minor New Google translator throws exception invalid_query for GROUP BY 2017-03-31 11:35:40 UTC
Red Hat Issue Tracker TEIID-4467 0 Minor Open Google translator throws exception invalid_query for GROUP BY 2017-03-31 11:35:40 UTC

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:


Note You need to log in before you can comment on or make changes to this bug.