#13375: Apache Hive(1.2.0) >>Unable to connect database for using Apache Hive 1.2.0 drivers in ADS lib folder

raghavsingh reported Jun 23, 2015 · tariqrahiman last modified Aug 17, 2015

Apache Hive(1.2.0) >>Unable to connect database for using Apache Hive 1.2.0 drivers in ADS lib folder

Dev	SachinPrakash
QA	tomconrad

Priority	Major
Complexity	Unknown

Component	Hive
Version	17.0

Product: Aqua Data Studio

Version: 17.0.0-dev-59

Build #: 44458

Build Date: 2015-Jun-22 06:20:21 PM

Database: Apache Hive 1.2.0 Hadoop 2.7

Drivers : Apache Hive 1.2.0

Authentication Type: UserName and Password(LDAP)

Location:

Connection Type: HiveServer 2
Distribution: Apache
Database: default

When we used Apache Hive 1.2.0 drivers in ADS , hive connection are not connected its throws error message in view logs.

I tried to Apache Hive connection

1. Connect Apache hive 1.2.0 with default drivers in ADS its connected successfully.

2. Connect Apache Hive 1.2.0 using Apache Hive 1.1.0 drivers in ADS its connect successfully.

3. Connect Apache Hive 1.1.0 using Apache Hive 1.1.0 drivers in ADS its connect successfully.

Error message:

java.lang.NoClassDefFoundError: org/apache/http/client/ServiceUnavailableRetryStrategy

at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)

at com.aquafold.aquacore.open.rdbms.drivers.hive.AQHiveDriver2.connect(Unknown Source)

at com.aquafold.aquacore.open.rdbms.drivers.hive.Q̤ꉘꑀꐺ class.b(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.Vꃻᝎᚪꌞ synchronized.Ma(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.Vꃻᝎᚪꌞ synchronized.ay(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.Vꃻᝎᚪꌞ synchronized.getConnection(Unknown Source)

at com.aquafold.datastudio.mainframe.dialog.connection.diagnostics.Jꅼꉃꅌ⡆ import.dC(Unknown Source)

at \\...\\ .\\हिñçêČάй語简�?한\\.Mꈮ̺ꇬᚸ$2.process(Unknown Source)

at com.common.ui.util.BackgroundThread.run(Unknown Source)

Caused by: java.lang.ClassNotFoundException: org.apache.http.client.ServiceUnavailableRetryStrategy

at java.net.URLClassLoader.findClass(URLClassLoader.java:381)

at java.lang.ClassLoader.loadClass(ClassLoader.java:424)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)

at java.lang.ClassLoader.loadClass(ClassLoader.java:357)

... 10 more

3 attachments

Hive Connection.png

Jun 23, 2015

108 KB
datastudio.log

Jun 23, 2015

2 KB
Register Hive Connection.png

Jun 23, 2015

143 KB

All Comments (4) Change History

SachinPrakash Jun 23, 2015

@tom: before you work on this issue, lets discuss. I've purposely kept it as a low priority issue for the time being.

anilkalshetti Jul 28, 2015

Build: ADSv17.0.0-dev-91

@Tom
ADS connected successfully to Hive.

Solution:
hive-jdbc.jar file is regular jar file that we copy in ADS drivers folder
For this hive version, need to use hive-jdbc-standalone.jar file from hive installation directory/hive/lib/
instead hive-jdbc.jar

Reason: Maybe the connection method is now in hive-jdbc-standalone.jar file

instead hive-jdbc.jar file

tomconrad Aug 4, 2015

Added httpcomponents-client-4.5 and httpcomponents-core-4.4.1 components. Hive connection now works with 1.2.0 and 1.2.1 jars. Please give it a try. Thanks, Tom

anilkalshetti Aug 5, 2015

Verified in ADS17.0.0-alpha-3

Working properly with Hive drivers from the distribution VM

hive-exec-x.xx.x-xxxx.x.x.jar

hive-jdbc-x.xx.x-xxxx.x.x.jar

hive-metastore-x.xx.x-xxxx.x.jar

hive-service-x.xx.x-xxxx.x.x.jar

Tested for below distribution and previous versions
a] Apache Hive 1.2.1

b] HDP 2.3.0GA - Hive 1.2.1
c] HDP 2.1TP - Hive 0.13
d] HDP 1.3 - Hive 0.11

e] CDH 5.4-2 Hive 1.1.0
f] CDH 5.4-2 Impala 220

Search Tips

Aqua Data Studio / nhilam

Apache Hive(1.2.0) >>Unable to connect database for using Apache Hive 1.2.0 drivers in ADS lib folder

3 attachments

Issue #13375

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Apache Hive(1.2.0) >>Unable to connect database for using Apache Hive 1.2.0 drivers in ADS lib folder

3 attachments

Issue #13375

Completion