Apache Drill JDBC Connection

KNIME Analytics Platform
1

I’ve been connecting to Apache Drill via JDBC connection using an older version of the JDBC .jar file (DrillJDBC41.jar). Due to a security upgrade to our hadoop cluster, I had to upgrade to the drill-jdbc-all-1.12.0-mapr.jar unfortunately, the Knime database reader node no longer works. When I execute the node, the credentials appear to be passed through ,but the sql code does not get passed.

Has anyone experienced this?

Thank you

Ray

2

Hi @ray_pruett

sorry, for the trouble you are having with this. It is hard to say what the cause is without any further information. Could you please provide your KNIME log file (at least the part that contains the error)?

You can view the KNIME log by going to the menu entry View > KNIME log in KNIME Analytics Platform.

Best,
Björn