topic Re: Getting java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver while trying trying to connect to hive in Talend Studio

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

Ray0801 — Sat, 16 Nov 2024 00:41:17 GMT

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)

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

Anonymous — Thu, 04 Feb 2021 13:32:26 GMT

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?

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

Ray0801 — Thu, 04 Feb 2021 13:47:44 GMT

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 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

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

Anonymous — Fri, 05 Feb 2021 06:50:36 GMT

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

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

Ray0801 — Sun, 07 Feb 2021 07:21:27 GMT

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.

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

Anonymous — Mon, 08 Feb 2021 09:51:46 GMT

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