Connection to Hive using JDBC Driver in KNIME

hive
#1

Dear coleegs,

I am trying to connect to Hive using a JDBC Driver and DB Connector node in KNIME. Knox thrust certificate is used. Unfortunately, it doesn’t work in KNIME. Nevertheless, it works using some DB development tools. So the connection string, thrust certificate and driver must be fine.

Below you will find my settings and outcomes. Thank you in advance for your answers. Please let me know if any additional information is required.

Kind regards

Oleksii Nikulin

PS. knime.ini file is filled with following statements:
-Djavax.net.ssl.trustStore=C:/Trust_Cert/knox-DB.jks
-Djavax.net.ssl.trustStorePassword=The_Password

Connection string:
jdbc:hive2://:/default;transportMode=http;httpPath=gateway/<cluster_name>/hive;ssl=true;sslTrustStore=C:/Trust_Cert/knox-DB.jks;trustStorePassword=The_Password

(all <[text]> values are substituted by real values)

Outcome:
WARN DB Connector 0:1 Couldn’t fetch SQL keywords from database.
ERROR DB Connector 0:1 Execute failed: DB Session is invalid. Method not supported

0 Likes

#2

Can you try the Hive Connector Node together with your parameters in the JDBC parameters tab? KNIME has the open source Hive driver already on board and the Hive Connector Node use it as default. The Node has some Hive specific connection settings defined as default (e.g. disabled transactions).

Kind regards
Sascha

2 Likes