Also try using port number 5181 in your drill-override.conf, instead of 2181, and then stop and start Drillbit and re-run your program.
On Tue, Jul 12, 2016 at 1:08 PM, Khurram Faraaz <kfar...@maprtech.com> wrote: > This one works just fine for me > > final String URL_STRING = "jdbc:drill:schema=dfs.tmp;drillbit=<IPADDRESS>"; > > replace IPADDRESS with your IP address in the above line. > > On Tue, Jul 12, 2016 at 12:08 PM, Krishnaprasad A S < > krishna.pra...@flytxt.com> wrote: > >> Yes, I tried with url *jdbc:drill:drillbit=<IP>:31010* but same error, >> Error in zeppelin console, >> java.net.ConnectException: Connection refused at >> java.net.PlainSocketImpl.socketConnect(Native Method) at >> >> java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) >> at >> >> java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) >> .... >> >> *drill-override.conf * >> drill.exec: { >> cluster-id: "drillbits1", >> zk.connect: "dk-slv8:2181" >> } >> >> Some more details, >> I'm querying from hdfs (select count(*) from `dfs`.`/POC/Sample10000.csv`) >> the same query works with Drill Web UI. >> Also the errors are logged in 'zeppelin-hadoop-dk-slv8.log' and not in >> 'zeppelin-interpreter-jdbc-hadoop-dk-slv8.log' >> >> I think there is something I'm missing because I tried removing the >> drill.url and kept it blank again the same error is coming. >> But there is no host or port mentioned for the ConnectException: >> Connection >> refused. >> >> >> >> On Tue, Jul 12, 2016 at 3:31 AM, Andries Engelbrecht < >> aengelbre...@maprtech.com> wrote: >> >> > Have you tried to connect to a drillbit directly from Zeppelin using the >> > jdbc url jdbc:drill:drillbit=<hostname>:31010? >> > >> > What does your drill-override.conf file look like? >> > >> > >> > > On Jul 11, 2016, at 2:33 PM, Krishnaprasad A S < >> > krishna.pra...@flytxt.com> wrote: >> > > >> > > 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 >> > >>>>> >> > >>>>> >> > >>> >> > >>> >> > >> > >> >> >> -- >> Krishnaprasad A S >> Lead Engineer >> Flytxt >> Skype: krishnaprasadas >> M: +91 8907209454 | O: +91 471.3082753 | F: +91 471.2700202 >> www.flytxt.com | Visit our blog <http://blog.flytxt.com/> | Follow us >> <http://www.twitter.com/flytxt> | Connect on LinkedIn >> < >> http://www.linkedin.com/company/22166?goback=%2Efcs_GLHD_flytxt_false_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2&trk=ncsrch_hits >> > >> > >