Getting java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver while trying trying to connect to hive

[Ray0801]

Exception in component tHiveConnection_1 (hdfs_hive)

java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at local_project.hdfs_hive_0_1.hdfs_hive.tHiveConnection_1Process(hdfs_hive.java:355)

at local_project.hdfs_hive_0_1.hdfs_hive.runJobInTOS(hdfs_hive.java:876)

at local_project.hdfs_hive_0_1.hdfs_hive.main(hdfs_hive.java:725)

[Anonymous]

Hello,

your job is missing the jar containing the class "org.apache.hive.jdbc.HiveDriver". Can you please try to download insert the needed jar using a tlibraryload component?

[Ray0801]

Hey @Sana SAFFAR​ ,

I tried adding hive-apache-jdbc-0.13.1-9&hive-jdbc-3.1.2 jars but neither works.

Getting this error after adding these two jars

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/http/HttpRequestInterceptor

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

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at local_project.hdfs_hive_0_1.hdfs_hive.tHiveConnection_1Process(hdfs_hive.java:499)

at local_project.hdfs_hive_0_1.hdfs_hive.tLibraryLoad_1Process(hdfs_hive.java:399)

at local_project.hdfs_hive_0_1.hdfs_hive.runJobInTOS(hdfs_hive.java:1017)

at local_project.hdfs_hive_0_1.hdfs_hive.main(hdfs_hive.java:866)

Caused by: java.lang.ClassNotFoundException: org.apache.http.HttpRequestInterceptor

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

... 7 more

[Anonymous]

Hello,

Could you please clarify in which Talend version/edition you are?

Are you using any webservice component in your job?

Talend Studio requires specific third-party Java libraries or database drivers to be installed to connect to sources and targets.

Those libraries or database drivers, known as external modules, may be required by some of Talend components or by some connection wizards or by both. Due to license restrictions, Talend may not be able to ship some of these external modules within Talend Studio. You need to install them for your Studio to functional properly.

Please refer to online documentation about: TalendHelpCenter: Installing external modules

Best regards

Sabrina

[Ray0801]

Hey @Xiaodi Shi​ I am trying to use the Talend Open Studio for Big Data 7.3.1 in Windows 10 ,I do know how to import external modules,but I am not able to narrow down which jar file is needed here.

[Anonymous]

Hello,

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

The error indicates the requires JDBC driver is missing or the installed driver is not compatible with the current Hive version you are using.

Here is online documentation for talend open studio bigdata V 7.3.1

TalendHelpCenter: Supported Big Data platforms

Best regards

Sabrina