[SOLVED] Strange behaviour Impala Connector (legacy) after moving Workspace

Hi Andres,
we needed the flexibility that the approach with the user defined URL templates provides us. We will be working on the UI to make it easier for you in the future to provide the correct values.

When you register the driver please make sure to select impala as database type.

the correct URL template for the Cloudera Impala driver is

jdbc:impala://<host>:<port>/[database]

In the Impala Connector node dialog make sure that you have selected your driver. During execution , and [database] are replaced with the values from the node dialog

The <> brackets indicate mandatory values whereas indicates an optional value.

To see the generated JDBC URL you can enable the JDBC logging via the Advanced tab of the Impala Connector node

Once enabled all JDBC operations are logged into the KNIME log file which you can open via View->Open KNIME log

Bye
Tobias

1 Like