Bug 1024875
| Summary: | Teiid connection metadata import leaves padding spaces for Hive column names | ||
|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Filip Nguyen <fnguyen> |
| Component: | Tooling | Assignee: | Filip Nguyen <fnguyen> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | |
| Severity: | urgent | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.0.0 | CC: | atangrin, lfabriko, vhalbert |
| Target Milestone: | ER4 | ||
| Target Release: | 6.0 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: |
When importing Hive tables using Teiid Designer, padding spaces are being introduced into column names. It is proposed that this will be fixed by allowing users to set relevant importer properties, such as trimColumnNames, by supplying arbitrary name-value properties through the wizard GUI.
|
Story Points: | --- |
| Clone Of: | Environment: | ||
| Last Closed: | 2014-03-10 18:39:07 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
|
Description
Filip Nguyen
2013-10-30 14:29:52 UTC
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 |