[teiid-issues] [JBoss JIRA] (TEIID-3580) Hive 0.13.1 JDBC jars makes queries run slow

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3580:
---------------------------------------

There has been no movement on their community issue.  If this issue still persists with later versions of Hive it looks like the only workaround that we could pursue is to always issue select * for simple queries and then filter the columns on our side.

> Hive 0.13.1 JDBC jars makes queries run slow
> --------------------------------------------
>
>                 Key: TEIID-3580
>                 URL: https://issues.jboss.org/browse/TEIID-3580
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.7.3
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>         Attachments: threaddump-1437508266001.tdump
>
>
> When using the JDBC jars for Hive 0.13.1 running on HDP 2.1, queries executed against table 'default.sample_07' takes approximately 20-30 seconds to return.
> The Hive JDBC jars for version 0.13.1 can be found here :
> https://github.com/vchintal/hive-jdbc-jars-archive
> Alternatively a ready-to-go modules can be downloaded from here for testing:
> https://drive.google.com/file/d/0BxJhoZ1V34QHSmgzTlBRVktZaGM/
> Use the following driver snippet when using the above mentioned module:
> <driver name="hive" module="org.apache.hadoop.hive:0.13.1">
>       <driver-class>org.apache.hive.jdbc.HiveDriver</driver-class>
> </driver>



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)