[teiid-issues] [JBoss JIRA] (TEIID-2998) problems with DDL returned for dynamic vdb with google spreadsheet source
Steven Hawkins (JIRA)
issues at jboss.org
Fri Jun 13 14:20:37 EDT 2014
[ https://issues.jboss.org/browse/TEIID-2998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12976172#comment-12976172 ]
Steven Hawkins commented on TEIID-2998:
---------------------------------------
For example the raw json we are getting back from a similar example I have is:
google.visualization.Query.setResponse({"version":"0.6","reqId":"0","status":"ok","sig":"1124987261","table":{"cols":[{"id":"A","label":"aa aa1 c","type":"string"},{"id":"B","label":"bb bb1 d","type":"string"},{"id":"C","label":"cc cc1 e","type":"string"}],"rows":[]}});
If I don't use all string data - for example having just the first row as strings, then things seem to work appropriately. So I don't think this is something that we should yet attempt to address on our side.
> problems with DDL returned for dynamic vdb with google spreadsheet source
> -------------------------------------------------------------------------
>
> Key: TEIID-2998
> URL: https://issues.jboss.org/browse/TEIID-2998
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: AdminApi
> Affects Versions: 8.7
> Reporter: Mark Drilling
> Assignee: Steven Hawkins
> Attachments: ChromeSheet.png, FirefoxSheet.png, GoogleSpreadsheetJIRA.txt
>
>
> I am seeing inconsistent DDL returned for dynamic VDB with a google spreadsheet source. In the same google account, I created two spreadsheets. One was created in firefox browser, one was created in chrome browser (don't know why that matters)
> See the attached document showing a comparison of the dynamic VDBs and the DDL that I got back. The only difference is that the source was pointing to a different spreadsheet.
> Notice that the DDL for the "ChromeSheet" returns the concatenated datavalues for the column name. But it includes a NIS OPTION for the column name.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
More information about the teiid-issues
mailing list