[teiid-issues] [JBoss JIRA] (TEIID-2524) Hive metadata import leaves whitespace characters in column names

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2524?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12778939#comment-12778939 ] 

Steven Hawkins commented on TEIID-2524:
---------------------------------------

So this is due 0.10.0 specific: 

https://issues.apache.org/jira/browse/HIVE-3140

which appears to be addressed by:

https://issues.apache.org/jira/browse/HIVE-4191

or possibly (which has yet to be committed)

https://issues.apache.org/jira/browse/HIVE-4545

The workaround is only generally safe as long as their column names cannot contain trailing/leading spaces.  If they can, then we'd have to add an option for this trim behavior otherwise it looks like it is not an issue for 0.09.0 or 0.11.0.
                
> Hive metadata import leaves whitespace characters in column names
> -----------------------------------------------------------------
>
>                 Key: TEIID-2524
>                 URL: https://issues.jboss.org/browse/TEIID-2524
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.4
>            Reporter: Filip Nguyen
>            Assignee: Steven Hawkins
>
> When hive translator starts with the newest Hive it runs "describe" command which returns Hive column names with white spaces.
> Maybe just use trim() in HiveMetadataProcessor.java?  
>   String name = rs.getString(1).trim();

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira