Are you running Drill in embedded mode or clustered mode? If in embedded mode you may want to try to connect directly to the drillbit jdbc:drill:drillbit=<hostname>:31010
It looks like you are trying to connect to a zk with a drill cluster, and your setup may just be embedded mode. --Andries > On Jul 11, 2016, at 12:55 PM, Krishnaprasad A S <[email protected]> > wrote: > > hi, > I'm trying to create a drill interpreter in zeppelin using the existing > jdbc interpreter. > > *drill.url = jdbc:drill:zk=<host>:2181/drill/drillbits1drill.driver = > org.apache.drill.jdbc.Driver* > my drillbit runs on the same server as of zeppelin. > > Added the dependency 'apache-drill-1.7.0/jars/drill-jdbc-all-1.7.0.jar' in > zeppelin > I'm the getting the following error while running a sample SQL from > zeppelin, > > ERROR [2016-07-12 01:11:41,946] ({pool-1-thread-4} > NotebookServer.java[afterStatusChange]:1135) - Error > org.apache.zeppelin.interpreter.InterpreterException: > org.apache.zeppelin.interpreter.InterpreterException: > org.apache.thrift.transport.TTransportException: java.net.ConnectException: > Connection refused > at > org.apache.zeppelin.interpreter.remote.RemoteInterpreter.init(RemoteInterpreter.java:165) > at > org.apache.zeppelin.interpreter.remote.RemoteInterpreter.getFormType(RemoteInterpreter.java:328) > at > org.apache.zeppelin.interpreter.LazyOpenInterpreter.getFormType(LazyOpenInterpreter.java:105) > at org.apache.zeppelin.notebook.Paragraph.jobRun(Paragraph.java:260) > at org.apache.zeppelin.scheduler.Job.run(Job.java:176) > at > org.apache.zeppelin.scheduler.RemoteScheduler$JobRunner.run(RemoteScheduler.java:328) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at > java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > at java.lang.Thread.run(Thread.java:722) > Caused by: org.apache.zeppelin.interpreter.InterpreterException: > org.apache.thrift.transport.TTransportException: java.net.ConnectException: > Connection refused > at > org.apache.zeppelin.interpreter.remote.ClientFactory.create(ClientFactory.java:53) > at > org.apache.zeppelin.interpreter.remote.ClientFactory.create(ClientFactory.java:37) > at > org.apache.commons.pool2.BasePooledObjectFactory.makeObject(BasePooledObjectFactory.java:60) > at > org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:861) > at > org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:435) > at > org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:363) > at > org.apache.zeppelin.interpreter.remote.RemoteInterpreterProcess.getClient(RemoteInterpreterProcess.java:184) > at > org.apache.zeppelin.interpreter.remote.RemoteInterpreter.init(RemoteInterpreter.java:163) > ... 13 more > Caused by: org.apache.thrift.transport.TTransportException: > java.net.ConnectException: Connection refused > at org.apache.thrift.transport.TSocket.open(TSocket.java:187) > at > org.apache.zeppelin.interpreter.remote.ClientFactory.create(ClientFactory.java:51) > ... 20 more > Caused by: java.net.ConnectException: Connection refused
