Marco Ardito created TEIID-4098:
-----------------------------------
Summary: Always preserve columns order in google spreadsheets models
Key: TEIID-4098
URL:
https://issues.jboss.org/browse/TEIID-4098
Project: Teiid
Issue Type: Feature Request
Affects Versions: 9.0
Reporter: Marco Ardito
Assignee: Steven Hawkins
Priority: Minor
I recently started using google spreadsheet datasources, and noticed that - at least
sometime - the DDL model created by teiid has all columns but in a different (sort of
random) order. This happened in particular using a google spreadsheet generated (linked
to) google form, see forum reference attached.
Google form allows users to fill a lot of fields, which are collected as record columns in
the google spreadsheet, then teiid makes that data available for integration with other
sources - which is awesome, btw.
Creating a view in the VDB works anyway, since the query selects column
"letters" like SELECT A,B,C and the right columns are selected, but having the
model completely different from the source is weird and makes it difficult to work with it
directly, if needed.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)