Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1244803 (TEIID-3580)

Summary:	Hive 0.13.1 JDBC jars makes queries run slow
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	dsteigne
Component:	Teiid	Assignee:	jolee
Status:	CLOSED NOTABUG	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	6.1.0	CC:	atangrin, dlesage, drieden, jolee
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:	There is a performance issue when the Hive 0.13.1 JDBC JARs are running on HDP 2.1 leading to very slow execution of queries.	Story Points:	---
Clone Of:		Environment:
Last Closed:	2015-09-17 19:50:41 UTC	Type:	Support Patch
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description dsteigne 2015-07-20 13:49:06 UTC

Describe the issue: 
See https://issues.jboss.org/browse/TEIID-3580

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>


Suggestions for improvement: 

Additional information:

Comment 2 JBoss JIRA Server 2015-07-20 15:08:20 UTC

Ramesh Reddy <rareddy> updated the status of jira TEIID-3580 to Resolved

Comment 3 JBoss JIRA Server 2015-07-20 15:10:11 UTC

Steven Hawkins <shawkins> updated the status of jira TEIID-3580 to Reopened

Comment 4 JBoss JIRA Server 2015-08-04 13:21:43 UTC

Steven Hawkins <shawkins> updated the status of jira TEIID-3580 to Resolved

Comment 5 jolee 2015-09-17 19:50:41 UTC

This issue has migrated to https://issues.apache.org/jira/browse/HIVE-11454

Currently nothing for us to do so closing and removing as blocker.