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

[Anonymous]

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

[iamabhishek]

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

[Anonymous]

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