[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=13091474#comment-13091474 ] 

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

Is this the same EAP / datasource you were using for your web app?  The threaddump just confirms that it's a normal (non-prepared) query execution from the perspective of Teiid.  What is the query you are executing, and just to make sure have you confirmed that the query plan is pushing what you expect to the source.

> 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.3.15#6346)