I can see all the 4 drillbits in ui. Aso I tried the query in web ui before running it in zeppelin. In web ui it works currently. Then what may be the issue.? On Jul 12, 2016 3:00 AM, "Andries Engelbrecht" <aengelbre...@maprtech.com> wrote:
What happens if you try to connect to a drillbit directly? This will help to see if it is a zk connection issue. Also I assume the dill cluster is up and running, and if you go to the webUI it shows all drillbits in the cluster connected and running. > On Jul 11, 2016, at 2:27 PM, Krishnaprasad A S <krishna.pra...@flytxt.com> wrote: > > 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 >>>> >>>> >> >>
