question Re: what's the latest hive-jdbc version supported in HDP 2.6 in Archives of Support Questions (Read Only)

what's the latest hive-jdbc version supported in HDP 2.6

yogen — Sun, 15 Oct 2017 15:26:04 GMT

I tried the latest I find in maven repo - but it didn't work. the only version I got working is hive-jdbc-2.0.0

Re: what's the latest hive-jdbc version supported in HDP 2.6

ahadjidj — Sun, 15 Oct 2017 15:54:08 GMT

@Yair Ogen

Have you tried the Hive-JDBC available on Hortonworks Add-ons download page ?

https://hortonworks.com/downloads/#addons

Re: what's the latest hive-jdbc version supported in HDP 2.6

yogen — Sun, 15 Oct 2017 17:19:22 GMT

Thanks. Is this is for simba specifically?

My app is a jdbc based app - and I get the jars using maven and just set the driver in config and expect the code to just work.

From the zip for jdbc 4.1 not clear which version of hive-jdbc is used?

For example this zip uses the HS1Driver while I thought I should use: org.apache.hive.jdbc.HiveDriver

Re: what's the latest hive-jdbc version supported in HDP 2.6

asirna — Sun, 15 Oct 2017 19:34:06 GMT

@Yair Ogen,

You can find a jdbc jar under ( /usr/hdp/current/hive-client/jdbc) folder.

Thanks,

Aditya

Re: what's the latest hive-jdbc version supported in HDP 2.6

yogen — Sun, 15 Oct 2017 20:33:42 GMT

In the hive node I don't have a jdbc folder there:

This is what I have:

drwxr-xr-x  7 root root      4096 Sep 27 13:31 ./
drwxr-xr-x 35 root root      4096 Sep 27 15:16 ../
drwxr-xr-x  3 root root      4096 Sep 27 13:28 bin/
lrwxrwxrwx  1 root root        23 Sep 27 13:31 conf -> /etc/hive/2.6.2.0-205/0/
drwxr-xr-x  3 root root      4096 Sep 27 13:28 doc/
-rw-r--r--  1 root root 106117252 Aug 26 12:31 hive.tar.gz
drwxr-xr-x  5 root root     12288 Sep 27 15:25 lib/
drwxr-xr-x  2 root root      4096 Sep 27 13:28 man/
drwxr-xr-x  3 root root      4096 Sep 27 13:28 scripts/

Re: what's the latest hive-jdbc version supported in HDP 2.6

asirna — Sun, 15 Oct 2017 21:12:43 GMT

@Yair Ogen,

I did a find for hive-jdbc jars and got the below result. Check if any of the paths exist in your setup.

/usr/hdp/2.6.2.0-205/spark2/jars/hive-jdbc-1.21.2.2.6.2.0-205.jar

/usr/hdp/2.6.2.0-205/hive/lib/hive-jdbc.jar

/usr/hdp/2.6.2.0-205/hive/lib/hive-jdbc-1.2.1000.2.6.2.0-205.jar

/usr/hdp/2.6.2.0-205/hive/jdbc/hive-jdbc-1.2.1000.2.6.2.0-205-standalone.jar

/usr/hdp/2.6.2.0-205/hive2/lib/hive-jdbc-2.1.0.2.6.2.0-205.jar

/usr/hdp/2.6.2.0-205/hive2/lib/hive-jdbc.jar

/usr/hdp/2.6.2.0-205/hive2/jdbc/hive-jdbc-2.1.0.2.6.2.0-205-standalone.jar

/usr/hdp/2.6.2.0-205/oozie/share/lib/hive2/hive-jdbc-1.2.1000.2.6.2.0-205.jar

/usr/hdp/2.6.2.0-205/oozie/libserver/hive-jdbc-1.2.1000.2.6.2.0-205.jar

/usr/hdp/2.6.2.0-205/oozie/libtools/hive-jdbc-1.2.1000.2.6.2.0-205.jar

/usr/hdp/2.6.2.0-205/zeppelin/interpreter/jdbc/hive-jdbc-1.2.1000.2.6.2.0-205.jar

Thanks,

Aditya

Re: what's the latest hive-jdbc version supported in HDP 2.6

asirna — Mon, 16 Oct 2017 15:04:00 GMT

@Yair Ogen,

Did this help you. Can you please accept the answer if it worked for you. That will help the community to find out answers quickly

Re: what's the latest hive-jdbc version supported in HDP 2.6

yogen — Mon, 16 Oct 2017 15:24:04 GMT

the comment helped not the original answer - but I can't mark a comment with 'accept'

Re: what's the latest hive-jdbc version supported in HDP 2.6

asirna — Mon, 16 Oct 2017 15:28:09 GMT

@Yair Ogen,

I did a find for hive-jdbc jars and got the below result. Check if any of the paths exist in your setup

/usr/hdp/2.6.2.0-205/spark2/jars/hive-jdbc-1.21.2.2.6.2.0-205.jar

/usr/hdp/2.6.2.0-205/hive/lib/hive-jdbc.jar

/usr/hdp/2.6.2.0-205/hive/lib/hive-jdbc-1.2.1000.2.6.2.0-205.jar

/usr/hdp/2.6.2.0-205/hive/jdbc/hive-jdbc-1.2.1000.2.6.2.0-205-standalone.jar

/usr/hdp/2.6.2.0-205/hive2/lib/hive-jdbc-2.1.0.2.6.2.0-205.jar

/usr/hdp/2.6.2.0-205/hive2/lib/hive-jdbc.jar

/usr/hdp/2.6.2.0-205/hive2/jdbc/hive-jdbc-2.1.0.2.6.2.0-205-standalone.jar

/usr/hdp/2.6.2.0-205/oozie/share/lib/hive2/hive-jdbc-1.2.1000.2.6.2.0-205.jar

/usr/hdp/2.6.2.0-205/oozie/libserver/hive-jdbc-1.2.1000.2.6.2.0-205.jar

/usr/hdp/2.6.2.0-205/oozie/libtools/hive-jdbc-1.2.1000.2.6.2.0-205.jar

/usr/hdp/2.6.2.0-205/zeppelin/interpreter/jdbc/hive-jdbc-1.2.1000.2.6.2.0-205.jar

Thanks,

Aditya

Re: what's the latest hive-jdbc version supported in HDP 2.6

asirna — Mon, 16 Oct 2017 15:28:51 GMT

@Yair Ogen,

I wrote the comment as a separate answer. Can you please accept that.

Thanks,

Aditya