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