I went through the same link before configuring the interpreter, also there is no security configured. On Jul 12, 2016 2:48 AM, "Andries Engelbrecht" <aengelbre...@maprtech.com> wrote:
> Do you have security configured on the Drill cluster? If so make sure to > add the user and password info for the Drill connection. > > Some good info for configuring Zeppelin with Drill here > > https://community.mapr.com/docs/DOC-1493 < > https://community.mapr.com/docs/DOC-1493> > > --Andries > > > > On Jul 11, 2016, at 2:13 PM, Krishnaprasad A S < > krishna.pra...@flytxt.com> wrote: > > > > My drill runs in clustered mode, with 4 drillbits running in 4 nodes. I > > started it using drillbit.sh start command. > > On Jul 12, 2016 2:18 AM, "Andries Engelbrecht" < > aengelbre...@maprtech.com> > > wrote: > > > >> 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 < > >> krishna.pra...@flytxt.com> 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 > >> > >> > >