Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Who agreed with this topic

Hue, JDBC and my JAR file

New Contributor

Dear all,

I am struggeling with some problems regarding a JAR file and HUE. 


As outlined here it's possible to integrate a database in HUE. 

So I try to do this as well. Therefor I downloaded a JAR file and try to integrate this in HUE. 


So I added a notebook and my code looks like the following lines


name = Hive
interface = hiveserver2
options='{"url": "jdbc:drill:zk=r2c00.pmd.local:2181,r2c01.pmd.local:2181,r2c02.pmd.local:2181/drill/pacluster;schema=pacs2","driver": "org.apache.drill.jdbc.Driver","user": "admin","password": "admin"}'


I see my notebook called JDBC




If I want to execute the following code 

select * from pacs2.pacs2.campaign limit 10


I get the following error


An error occurred while calling z:java.sql.DriverManager.getConnection. : java.sql.SQLException: No suitable driver found for jdbc:drill:zk=r2c00.pmd.local:2181,r2c01.pmd.local:2181,r2c02.pmd.local:2181/drill/pacluster;schema=pacs2 at java.sql.DriverManager.getConnection( at java.sql.DriverManager.getConnection( at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke( at sun.reflect.DelegatingMethodAccessorImpl.invoke( at java.lang.reflect.Method.invoke( at py4j.reflection.MethodInvoker.invoke( at py4j.reflection.ReflectionEngine.invoke( at py4j.Gateway.invoke( at py4j.commands.AbstractCommand.invokeMethod( at py4j.commands.CallCommand.execute( at at


Obviously HUE is not possible to find the driver. Surprisingly if I try to connect to the database via SQuirrel SQL it's no problem.



So my key question is where I have to locate the JDBC jar file? Is there a specific location for this file?


I am using HUE 3.11 and Cloudera CDH 5.9.0.


Thanks for all your help!





Who agreed with this topic