Perhaps try to create a separate interpreter.
Create a new interpreter and call it Drill or another name than just jdbc.
Below an example I did for a MapR cluster - adjust as needed
Also make sure all hostnames can be properly resolved in the network!! (seen
way too many issues due to this)
Perhaps add a user and password even if security is not configured.
Name : Drill
Interpreter : jdbc
zeppelin.interpreter.localRepo <your local repo>
common.max_count 1000
drill.user drill
drill.password password
drill.driver org.apache.drill.jdbc.Driver
drill.url jdbc:drill:zk=<hostname>:5181/drill/cluster-drillbits
Dependencies
Artifacts
/opt//mapr/drill/drill-1.6.0/jars/jdbc-driver/drill-jdbc-all-1.6.0.jar
--Andries
> On Jul 12, 2016, at 10:48 AM, Krishnaprasad A S <krishna.pra...@flytxt.com>
> wrote:
>
> 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>
