[teiid-issues] [JBoss JIRA] (TEIID-4858) hive translator is extremely slow

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-4858:
---------------------------------------

There is no known case where Teiid/EAP behaves differently when accessing a Hive source vs. just going through JDBC.  You will need to ensure you are executing the exact same source query either way and that you are using the same libraries etc.

If you think that you are seeing difference the first thing to do is to isolate the EAP DataSource to compare vs direct JDBC - more than likely any issue would be at that layer rather than with Teiid.

> hive translator is extremely slow
> ---------------------------------
>
>                 Key: TEIID-4858
>                 URL: https://issues.jboss.org/browse/TEIID-4858
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 8.12.9.6_3
>         Environment: Tested against JDV 6.3.4 and the Cloudera quickstart 5.8 VM with the Cloudera sample data loaded into hive
>            Reporter: Michael Echevarria
>            Assignee: Steven Hawkins
>
> When querying a table through the hive translator the results take close to 30 seconds to return.
> When querying a table through jdbc default results take under 1 second to return.
> Both use the same underlying jboss server datasource.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)