Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
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