My zookeeper runs on port 2181, thats why I used the same port.
I think drill won't start zookeeper by its own.
I also tried using url "jdbc:drill:schema=dfs.tmp;drillbit=<IPADDRESS>"
same error. Is there something I'm missing,
On Tue, Jul 12, 2016 at 1:11 PM, Khurram Faraaz <kfar...@maprtech.com>
wrote:
> 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
> >> >
> >>
> >
> >
>
--
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>
