Problem Importing Hive Tables, when using Teiid Connection >> Source model, is introducing padding spaces into column names. Why There is a problem with Hive 0.11 driver which introduces padding spaces into metadata (data types and column names). The problem has been resolved (TEIID-2524) but it is necessary that dynamic VDBs that import this metadata use importer property trimColumnNames property set to true. So it is probably needed to add this property to importVDB-vdb.xml in the case of hive translator import in the Designer. https://issues.jboss.org/browse/TEIIDDES-1905
Barry LaFond <blafond> made a comment on jira TEIIDDES-1905 I'm still unclear on what needs to change/fix in Teiid Designer?
Ramesh Reddy <rareddy> made a comment on jira TEIIDDES-1905 IMO, nothing, this should be rejected
Filip Nguyen <fnguyen> made a comment on jira TEIIDDES-1905 Ramesh, why it should not be an issue with 0.11 driver? I am using the driver and it leaves the padding spaces. Which renders the imported base table unusable. So your conclusion is that, user should import with spaces and fix the source model?
Ramesh Reddy <rareddy> made a comment on jira TEIIDDES-1905 Filip, this is error introduced by the Hive driver. In Teiid we added a import property for handling this gracefully. Now, it is user's duty to add this import property when using the "Teiid Connection" importer to properly import the metadata from the Hive, when using this particular version of the Hive driver. Or we need to make this "trimColums" to true by default in the Teiid. But not force this on Designer to provide. All the translators have multiple import properties that can be used to customize this importer, but so far Teiid does not have smarts in the system to expose what these properties are so that Designer can provide a intelligent GUI on top unless they hard code for each of the translator.
Filip Nguyen <fnguyen> made a comment on jira TEIIDDES-1905 Ramesh, sorry I didn't know it is possible to set importer property when importing using the Wizard. In that case you are right, this can be rejected.
Ramesh Reddy <rareddy> made a comment on jira TEIIDDES-1905 Needs TEIID-1911, to satisfy this need
Mark Drilling <mdrilling> updated the status of jira TEIIDDES-1911 to Resolved
Mark Drilling <mdrilling> made a comment on jira TEIIDDES-1911 Added ability in the wizard for user to supply arbitrary name-value properties. Verified that the properties were being passed correctly by passing "importer.tableNamePattern" to narrow the list of imported tables for a mysql import... Pull Request - https://github.com/Teiid-Designer/teiid-designer/pull/256
Mark Drilling <mdrilling> updated the status of jira TEIIDDES-1905 to Resolved
Mark Drilling <mdrilling> made a comment on jira TEIIDDES-1905 Resolved the related defect TEIIDDES-1911. With TEIIDDES-1911 changes, the user will now be able to pass a trim property in the importer.
Assuming this will be set to VERIFIED before GA - setting requires_doc_text- accordingly.
Barry LaFond <blafond> updated the status of jira TEIIDDES-1905 to Closed
Barry LaFond <blafond> updated the status of jira TEIIDDES-1911 to Closed