Trying to create a Hive table with tHiveCreateTable in Big Data edition, I get ClassNotFoundException: org.apache.hive.jdbc.HiveDriver

Anonymous — Sat, 16 Nov 2024 04:54:35 GMT

Hi,

In Talend Big Data edition, I am trying to create a Hive table with tHiveCreateTable palette. I am using like table utility in design. So it is basic Hive Query Language (HQL).

CREATE TABLE dummy4 AS SELECT * FROM DUMMY2

But it fails with basic error:

Starting job createHiveTable at 00:01 21/08/2019.

[statistics] connecting to socket on port 3674
[statistics] connected
Exception in component tHiveCreateTable_2 (createHiveTable)
java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launch

er.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at local_project.createhivetable_0_1.createHiveTable.tHiveCreateTable_2Process(createHiveTable.java:342)
at local_project.createhivetable_0_1.createHiveTable.runJobInTOS(createHiveTable.java:658)
at local_project.createhivetable_0_1.createHiveTable.main(createHiveTable.java:508)
[statistics] disconnected

Job createHiveTable ended at 00:01 21/08/2019. [exit code=1]

I do not know why it cannot find the jar file that I loaded earlier as below

hive-jdbc-3.1.1-standalone.jar

Appreciate any advice.

Thanks,

Mich

Re: Trying to create a Hive table with tHiveCreateTable in Big Data edition, I get ClassNotFoundException: org.apache.hive.jdbc.HiveDriver

iamabhishek — Wed, 21 Aug 2019 13:07:47 GMT

What is the "distribution" and "version" that you are using?

Re: Trying to create a Hive table with tHiveCreateTable in Big Data edition, I get ClassNotFoundException: org.apache.hive.jdbc.HiveDriver

Anonymous — Wed, 21 Aug 2019 15:43:04 GMT

Hi,

Thanks for the reply:

Talend is BD 7.2, Hive is 3.1.1 by Apache Hive. Hadoop 3.1. The Hive version is from the list not supported but still should work. Others like Squirrel SQL can connect to it OK.

What options do I have?

Cheers

topic Re: Trying to create a Hive table with tHiveCreateTable in Big Data edition, I get ClassNotFoundException: org.apache.hive.jdbc.HiveDriver in Talend Studio

Trying to create a Hive table with tHiveCreateTable in Big Data edition, I get ClassNotFoundException: org.apache.hive.jdbc.HiveDriver

Re: Trying to create a Hive table with tHiveCreateTable in Big Data edition, I get ClassNotFoundException: org.apache.hive.jdbc.HiveDriver

Re: Trying to create a Hive table with tHiveCreateTable in Big Data edition, I get ClassNotFoundException: org.apache.hive.jdbc.HiveDriver