Thanks a lot Kunal and Andries.
Post by Kunal Khatua
+1 to Andries' comment.
When you start Drill in Embedded mode, you are bringing up a single
standalone Drillbit without any Zookeeper that would otherwise allow
discovery of other Drillbits in the cluster.
Starting in embedded mode is done via SQLLine because in a practical
usage, a single Drillbit doesn't accomplish much, beyond just trying out
things (Drill or data exploration).
Once you have that running, then if a JDBC client needs to connect to
that, you need to tell your JDBC client where to connect. In this case,
since there is no Zookeeper (that, typically, listens on port 2181) that
has knowledge about your Drillbit running in embedded-mode, we need to
explicitly tell it to connect to the Drillbit server.
Hence, your JDBC URL needs to be
Hope that helps
Sent: Monday, August 07, 2017 8:17 AM
Subject: Re: Drill JDBC connection on windows in embedded node
Since embedded mode doesnât use ZK you need to connect directly to the
I followed the this link
connect to drill in JDBC mode .
*Have installed drill 1.11 on windows 10 in embedded mode .*
*Option1 :* jdbc:drill:zk=localhost:2181/drill/drillbits1
*Option 2* : jdbc:drill:zk=localhost:2181
*Option 3 *: jdbc:drill:zk=<hostname>:2181
I am getting below error with all the the options
Unexpected Error occurred attempting to open an SQL connection.
class java.io.IOException: Failure to connect to the zookeeper cluster
service within the allotted time of 10000 milliseconds
Appreciate the help .