[JBoss JIRA] (TEIID-4858) hive translator is extremely slow
- First Post
- Replies
- Stats
-
Go to
- ----- 2026 -----
- April
- March
- February
- January
- ----- 2025 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- 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-4858?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-4858.
-----------------------------------
Resolution: Done
After some testing, it does appear that the use of order by in hive introduces
significantly more overhead than expected (comparing to Teiid or databases). Relying on
Teiid sorting will generally be more performant.
So the default support was changed and a release note added.
We can revisit this if there are circumstances that still require order by pushdown.
hive translator is extremely slow
---------------------------------
Key: TEIID-4858
URL: https://issues.jboss.org/browse/TEIID-4858
Project: Teiid
Issue Type: Quality Risk
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
Fix For: 9.3
Attachments: fast.log, override1.png, override2.png, slow.log
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)
3253
days inactive
3253
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)