[teiid-issues] [JBoss JIRA] (TEIID-2538) Validate Apache Hive 0.11 version of Driver

[Filip Nguyen (JIRA)]

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

Filip Nguyen commented on TEIID-2538:
-------------------------------------

Need more information on this one. Is this referring to standard metadata-load that is happening during the VDB startup? I see no problem with this, but it is necessary to use the new "importer.trimColumNames" property, because there is a bug associated with 0.11 version of Hive driver. 

My test setup is as follows. I am using Hortonworks sandbox Hortonworks+Sandbox+1.3+VirtualBox+RC6.ova. Then I overlayed modules in the AS by those that can be found in  hortonworks tarball distro [1] (AFAIK it is not possible to get those Jars directly from SANDBOX VM). After starting the sandbox I deploy the driver to AS and a VDB with the "importer.trimColumNames" set to true. I am then able to query the VDB using standard JDBC client:

{noformat}
 ./run.sh localhost 31000 hadoop "select * from sample_07"
Executing using the TeiidDriver
Results
1: 00-0000,All Occupations,134354250,40690
2: 11-0000,Management occupations,6003930,96150
...
{noformat}

[1] http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.3.1/bk_installing_manually_book/content/rpm-chap15-2.html
                
> Validate Apache Hive 0.11 version of Driver
> -------------------------------------------
>
>                 Key: TEIID-2538
>                 URL: https://issues.jboss.org/browse/TEIID-2538
>             Project: Teiid
>          Issue Type: Task
>          Components: Misc. Connectors
>            Reporter: Ramesh Reddy
>            Assignee: Filip Nguyen
>             Fix For: 8.4.1
>
>
> There are report that the metadata does not load properly when used with Apache Hive 0.11 version of the JDBC driver. This needs to be validated and make any changes that are required. 
> Test with Hive driver that comes with the Hortonworks Sandbox distro

--
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