[teiid-issues] [JBoss JIRA] (TEIID-4825) Google translator throws Column doesn't exist in the worksheet
Steven Hawkins (JIRA)
issues at jboss.org
Fri Mar 24 14:10:00 EDT 2017
[ https://issues.jboss.org/browse/TEIID-4825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13384057#comment-13384057 ]
Steven Hawkins commented on TEIID-4825:
---------------------------------------
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)
More information about the teiid-issues
mailing list