I’m trying to create a connection between Dbeaver and Hive on a CDP 7.1.6 from a Mac OS Ventura 13.1 (22C65).
I used the Apache Hive connection option;
Put this sring on Host path on the main page…:
…and Host/IP, user and password on the SSH page (It is working fine).
On the Driver library added the jars files:
But I’m keep receiving this message:
Can't create driver instance
Error creating driver 'Hadoop / Apache Hive' instance.
Most likely required jar files are missing.
You should configure jars in driver settings.
Reason: can't load driver class 'org.apache.hive.jdbc.HiveDriver'
I don't know what to in drever settings.
Hi @fabio_bd_araujo ,
We recommend you to download the latest Cloudera JDBC Driver here:https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-21.htmlThen in your DBeaver connection settings, go to Edit Driver Settings button and then to tab Libraries.
There you will see the current jar, which is the default Apache Driver.
Remove and then add the downloaded Cloudera jar.
You should be able to connect using your usual string connection.
Ps: You don't need to add log4j libraries. Cloudera Driver already have a logging option.
Check the documentation here (page 27):
Note the class should be com.cloudera.hive.jdbc.HS2Driver
Make sure to use the parameters as detailed in the driver docs shared on the previous response
A sample KNOX JDBC string looks similar to this:
When all details have been entered, click on Test Connection
create connection between Dbeaver and Hive on a CDP 7.1.8 centos 7
i am also facing same issue in cluster Kerberos is enabled