Error when using Cloudera JDBC Driver at Hive Connector Node

Hi all,

I am using Knime Analytics Platform 4.1 locally and I try to connect via Hive Connector to Hive in Cloudera CDH 6.3.2 environment.
I have downloaded Cloudera Driver 2.6.9 via , extracted the jar files and “imported” the driver in Knime
using File->Preferences->Databases. At the new driver entry the Driver Class is automatically set to “com.cloudera.hive.jdbc.HS1Driver”.

Then I use the Hive Connector Node where I choose the “imported” driver and fill the host, port and database. But when I execute the node I receive the following error

ERROR : KNIME-Worker-9-Hive Connector 2:1 : : Node : Hive Connector : 2:1 : Execute failed: Selected JDBC driver does not support given JDBC url.
java.sql.SQLException: Selected JDBC driver does not support given JDBC url.

  • at org.knime.database.connection.UrlDBConnectionController.createConnection(*
  • at org.knime.database.connection.UserDBConnectionController.createConnection(*
  • at org.knime.database.connection.AbstractConnectionProvider.createConnection(*
  • at org.knime.database.connection.impl.DBConnectionManager.lambda$2(*
  • at*
  • at java.util.concurrent.ThreadPoolExecutor.runWorker(*
  • at java.util.concurrent.ThreadPoolExecutor$*
  • at*

Is there a way to find the JDBC url that this node creates in order to investigate what’s happening?

Thank you in advance,

Hi Ioanna,
please select the com.cloudera.hive.jdbc.HS2Driver not com.cloudera.hive.jdbc.HS1Driver as the driver class and make sure that the URL template looks like this: jdbc:hive2://:/[database]



Hi Tobias,

Thank you very much for your immediate response!

It works like a charm!

Thanks again,


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