Re: Drill JDBC Interpreter: Connection Refused

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)

Re: Drill JDBC Interpreter: Connection Refused

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

Re: Drill JDBC Interpreter: Connection Refused

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

Re: Drill JDBC Interpreter: Connection Refused

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=" same error. Is there something I'm missing, On Tue, Jul 12, 2016 at 1:11 PM, Khurram Faraaz wrote:

Re: Drill JDBC Interpreter: Connection Refused

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 wrote: > This one works just fine for me > > final String URL_STRING =

Re: Drill JDBC Interpreter: Connection Refused

This one works just fine for me final String URL_STRING = "jdbc:drill:schema=dfs.tmp;drillbit="; 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

Re: Drill JDBC Interpreter: Connection Refused

Yes, I tried with url *jdbc:drill:drillbit=: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

Re: Drill JDBC Interpreter: Connection Refused

Have you tried to connect to a drillbit directly from Zeppelin using the jdbc url jdbc:drill:drillbit=:31010? What does your drill-override.conf file look like? > On Jul 11, 2016, at 2:33 PM, Krishnaprasad A S > wrote: > > I can see all the 4 drillbits in ui. Aso

Re: Drill JDBC Interpreter: Connection Refused

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" wrote: What happens if you try to connect to a drillbit

Re: Drill JDBC Interpreter: Connection Refused

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,

Re: Drill JDBC Interpreter: Connection Refused

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" wrote: > Do you have security configured on the Drill cluster? If so make sure to > add the user and password info for

Re: Drill JDBC Interpreter: Connection Refused

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 --Andries > On Jul

Re: Drill JDBC Interpreter: Connection Refused

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" wrote: > Are you running Drill in embedded mode or clustered mode? > > If in embedded mode you may want to

Re: Drill JDBC Interpreter: Connection Refused

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=: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

Drill JDBC Interpreter: Connection Refused

hi, I'm trying to create a drill interpreter in zeppelin using the existing jdbc interpreter. *drill.url = jdbc:drill:zk=:2181/drill/drillbits1drill.driver = org.apache.drill.jdbc.Driver* my drillbit runs on the same server as of zeppelin. Added the dependency