Getting the following error connecting to hive
RROR Database Table Connector 3:1 Execute failed: org.knime.core.node.InvalidSettingsException: Driver “com.simba.hive.jdbc41.HS1Driver” does not accept URL: jdbc:hive2://XXXXXXX:10000
Getting the following error connecting to hive
RROR Database Table Connector 3:1 Execute failed: org.knime.core.node.InvalidSettingsException: Driver “com.simba.hive.jdbc41.HS1Driver” does not accept URL: jdbc:hive2://XXXXXXX:10000
@rameveer007
I noticed you are using “Database Table Connector”. Have you already tried the “Hive Connector” node which comes as part of the “KNIME Big Data Connectors” extension? It detects the presence of the com.simba.hive.jdbc41.HS2Driver driver and uses that automatically (if you absolutely want to use that driver). Apart from that, the Hive Connector node also contains its own Hive JDBC driver, which is based on the open-source Apache Hive JDBC driver, so there is not strictly a need to use the Simba-based driver you are using.
Thank you. I managed to solve it tonight. It did the following
Someone told me the hive Big Data Connector is a commercial license tied to it.
@rameveer007
Since KNIME 3.5, KNIME Big Data Connectors (which includes the Hive Connector) and our Spark integration are open-source (GPL license) and free for by use by anyone.
See here: https://www.knime.com/whats-new-in-knime-35#big-data
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.