I have restarted zeppelin each time. Also zeppelin runs on a drillbit node.
Please find below properties for jdbc interpreter,
name value
common.max_count 1000d
default.driver org.postgresql.Driver
default.password
default.url jdbc:postgresql://localhost:5432/
default.user gpadmin
drill.driver org.apache.drill.jdbc.Driver
drill.password
drill.url jdbc:drill:schema=dfs;drillbit=dk-slv8
hive.driver org.apache.hive.jdbc.HiveDriver
hive.password
hive.url jdbc:hive2://localhost:10000
hive.user hive
phoenix.driver org.apache.phoenix.jdbc.PhoenixDriver
phoenix.password
phoenix.url jdbc:phoenix:localhost:2181:/hbase-unsecure
phoenix.user phoenixuser
psql.driver org.postgresql.Driver
psql.password
psql.url jdbc:postgresql://localhost:5432/
psql.user phoenixuser
tajo.driver org.apache.tajo.jdbc.TajoDriver
tajo.url jdbc:tajo://localhost:26002/default
zeppelin.interpreter.localRepo
/data/installables/zeppelin-0.6.0-bin-all/local-repo/2BQT8WFCV
zeppelin.jdbc.concurrent.max_connection 10
zeppelin.jdbc.concurrent.use true
Dependencies
artifact exclude
/data/installables/apache-drill-1.7.0/jars/drill-jdbc-1.7.0.jar
Thanks,
Krishnaprasad
On Tue, Jul 12, 2016 at 8:06 PM, Andries Engelbrecht <
aengelbre...@maprtech.com> wrote:
> Perhaps share the Zeppelin interpreter config line by line so we can see.
> Properties and Dependencies.
>
> Also did you restart the interpreter after you made the config changes?
>
> I assume you are running Zeppelin on one of the Drill nodes, where is ZK
> located?
>
> --Andries
>
>
> > On Jul 12, 2016, at 5:31 AM, Krishnaprasad A S <
> krishna.pra...@flytxt.com> wrote:
> >
> > 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
> >
>
>
--
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>
