[JBoss JIRA] (TEIID-3580) Hive 0.13.1 JDBC jars makes queries run slow
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-3580?page=com.atlassian.jira.plugin...
]
Vijay Bhaskar Chintalapati commented on TEIID-3580:
---------------------------------------------------
Very interesting Steven! I executed the query "SELECT g_0.code, g_0.description,
g_0.total_emp, g_0.salary FROM sample_07 AS g_0" from the web app and its taking the
same 20 seconds to return. I run the same query from a standalone JDBC project and the
delay is the same : 20+ second. Whats your guess about what is happening ?
I run the same query against Hive 1.2.0 using the Hive 1.2.0 jars and the query returns
in less than a second.
So it safe to assume that the culprit is somewhere in the jars ?
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)
3458
days inactive
3458
days old
0 comments
1 participants
tags (0)
participants (1)
-
Vijay Bhaskar Chintalapati (JIRA)