Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
ArijitGiri1
Contributor
Contributor

Unable to establish Hive Connection

We are trying to establish Oracle and Hive connection in Talend 7.3. Oracle is working finr but while establishing Hive connection getting below error. We are using Hadoop open source utility where Hive version 3.1.2 being used.

 

Here we selected distribution "Custom - unsupported" for open source Apache Hadoop. Will appreciate if someone can help us.

 

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

Labels (3)
1 Reply
Anonymous
Not applicable

Hi

The error indicates the requires JDBC driver is missing or the installed driver is't compatible with the current Hive version 3.1.2 you are using. To do: check and find the right driver file, use tLiabraryLoad to load the drive file before ​tHiveCreateTable, eg:

tLiabraryLoad

|onsubjobok

tHiveCreateTable 

 

Regards

Shong