Connection to Hive using JDBC Driver in KNIME

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

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

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.