[teiid-issues] [JBoss JIRA] (TEIID-4825) Google translator throws Column doesn't exist in the worksheet

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13384057#comment-13384057 ] 

Steven Hawkins edited comment on TEIID-4825 at 3/24/17 3:23 PM:
----------------------------------------------------------------

This is similar to TEIID-4672.  Essentially the google-api has it's own rules as to when a column value is header or not.  If there is just a header row or even just string data - it's just treated as a data row.  With numeric content - it's automatically a header. 

This is a little thorny for us to undo.  Even if we make the metadata match what we expect,  queries that expect a header, such as update, operations will fail.

I'll look again to see if there is a quick resolution.  Otherwise it's simply the case that to google there is no header for the sheet in question and our metadata shouldn't treat it as having one.


was (Author: shawkins):
This is similar to TEIID-4672.  Essentially the google-api has it's own rules as to when a column value is header or not.  If there is just a header row or even just string data - it's just treated as a data row.  With numeric content - it's automatically a header. 

This is a little thorny for us to undo.  As even if we make the metadata match what we expect queries that expect a header, such as update operations will fail.

I'll look again to see if there is a quick resolution.  Otherwise it's simply the case that to google there is no header for the sheet in question and our metadata shouldn't treat it as having one.

> Google translator throws Column doesn't exist in the worksheet
> --------------------------------------------------------------
>
>                 Key: TEIID-4825
>                 URL: https://issues.jboss.org/browse/TEIID-4825
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.12.10.6_3
>            Reporter: Lucie Fabrikova
>            Assignee: Steven Hawkins
>             Fix For: 9.3
>
>         Attachments: gs-export-vdb.xml, server.log-dv635cr1
>
>
> If sheet (WikiData9) contains only string type columns, queries to that sheet fail with 'org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Column link doesn't exist in the worksheet WikiData9'
> If I added e.g. numeric or boolean column, it worked ok...



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)