Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4467

Google translator throws exception invalid_query for GROUP BY

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Minor Minor
    • Backlog
    • 8.12
    • Misc. Connectors
    • None
    • Hide
      • create google spreadsheet with name "bqt-tables" and worksheet "smalla", with column type NUMBER containing intkey
      • configure google resource adapter:
        <resource-adapter id="google2">
        <module slot="main" id="org.jboss.teiid.resource-adapter.google"/>
        <transaction-support>NoTransaction</transaction-support>
        <connection-definitions>
        <connection-definition class-name="org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory" jndi-name="java:/google2" enabled="true" use-java-context="true" pool-name="google2">
        <config-property name="BatchSize">
        4096
        </config-property>
        <config-property name="RefreshToken">
        XXX
        </config-property>
        <config-property name="AuthMethod">
        OAuth2
        </config-property>
        <config-property name="SpreadsheetName">
        bqt-tables
        </config-property>
        </connection-definition>
        </connection-definitions>
        </resource-adapter>
      • create dynamic vdb (see attached)
      • execute given query (see attached server.log)
      Show
      create google spreadsheet with name "bqt-tables" and worksheet "smalla", with column type NUMBER containing intkey configure google resource adapter: <resource-adapter id="google2"> <module slot="main" id="org.jboss.teiid.resource-adapter.google"/> <transaction-support>NoTransaction</transaction-support> <connection-definitions> <connection-definition class-name="org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory" jndi-name="java:/google2" enabled="true" use-java-context="true" pool-name="google2"> <config-property name="BatchSize"> 4096 </config-property> <config-property name="RefreshToken"> XXX </config-property> <config-property name="AuthMethod"> OAuth2 </config-property> <config-property name="SpreadsheetName"> bqt-tables </config-property> </connection-definition> </connection-definitions> </resource-adapter> create dynamic vdb (see attached) execute given query (see attached server.log)

      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)
      ...

        1. googlespreadsheet-vdb.xml
          5 kB
        2. server.log
          59 kB

              Unassigned Unassigned
              lfabriko@redhat.com Lucie Krejcirova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: