You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Perler, Eric" <er...@walgreens.com> on 2014/10/27 15:24:19 UTC
cant connect to drill with SQuriieL
Hello
Im trying to connect to drill using squirrel
i am using this URL...
jdbc:drill:zk=local.rcggs.com
I am able to telnet to zookeeper like so...
telnet local.rcggs.com 2181
but when i try to connect with squirrel i get this error...
java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.IllegalStateException: No DrillbitEndpoint can be found
Thanks for your assistance
Re: cant connect to drill with SQuriieL
Posted by Aditya <ad...@gmail.com>.
If you have followed the steps described in
https://cwiki.apache.org/confluence/display/DRILL/Installing+Drill+in+Distributed+Mode
to configure and start the DrillBit services, then it is running in
distributed mode. If you are starting it using SQLLine, then it is running
in embedded mode.
The ZooKeeper settings are configured in "drill-override.conf" located in
"$DRILL_HOME/conf/".
On Mon, Oct 27, 2014 at 5:20 PM, Perler, Eric <er...@walgreens.com>
wrote:
> thank you... can you tell me how to check these items..
>
> 1. DrillBits are running in distributed mode[1], and
> 2. Configured to use the same ZooKeeper.
>
>
> ________________________________________
> From: Aditya <ad...@gmail.com>
> Sent: Monday, October 27, 2014 7:16 PM
> To: drill
> Subject: Re: cant connect to drill with SQuriieL
>
> Hi Eric,
>
> This error indicates that the client was able to connect to the specified
> ZooKeeper but no DrilBit had registered itself to this instance. Could you
> check if
>
> 1. DrillBits are running in distributed mode[1], and
> 2. Configured to use the same ZooKeeper.
>
> If both of these are true, most likely your cluster id is set to a
> non-default value, in which case, you may want to use the full JDBC URL,
> i.e.
>
>
> jdbc:drill:zk=<zk_quorum>/drill/<cluster_ID>;schema=<schema_to_use_as_default>
>
> [1]
>
> https://cwiki.apache.org/confluence/display/DRILL/Installing+Drill+in+Distributed+Mode
>
> On Mon, Oct 27, 2014 at 7:24 AM, Perler, Eric <er...@walgreens.com>
> wrote:
>
> > Hello
> >
> >
> > Im trying to connect to drill using squirrel
> >
> >
> > i am using this URL...
> >
> >
> > jdbc:drill:zk=local.rcggs.com
> >
> >
> > I am able to telnet to zookeeper like so...
> >
> >
> > telnet local.rcggs.com 2181
> >
> >
> > but when i try to connect with squirrel i get this error...
> >
> >
> > java.util.concurrent.ExecutionException: java.lang.RuntimeException:
> > java.lang.IllegalStateException: No DrillbitEndpoint can be found
> >
> > Thanks for your assistance
> >
> >
> >
> >
>
Re: cant connect to drill with SQuriieL
Posted by "Perler, Eric" <er...@walgreens.com>.
thank you... can you tell me how to check these items..
1. DrillBits are running in distributed mode[1], and
2. Configured to use the same ZooKeeper.
________________________________________
From: Aditya <ad...@gmail.com>
Sent: Monday, October 27, 2014 7:16 PM
To: drill
Subject: Re: cant connect to drill with SQuriieL
Hi Eric,
This error indicates that the client was able to connect to the specified
ZooKeeper but no DrilBit had registered itself to this instance. Could you
check if
1. DrillBits are running in distributed mode[1], and
2. Configured to use the same ZooKeeper.
If both of these are true, most likely your cluster id is set to a
non-default value, in which case, you may want to use the full JDBC URL,
i.e.
jdbc:drill:zk=<zk_quorum>/drill/<cluster_ID>;schema=<schema_to_use_as_default>
[1]
https://cwiki.apache.org/confluence/display/DRILL/Installing+Drill+in+Distributed+Mode
On Mon, Oct 27, 2014 at 7:24 AM, Perler, Eric <er...@walgreens.com>
wrote:
> Hello
>
>
> Im trying to connect to drill using squirrel
>
>
> i am using this URL...
>
>
> jdbc:drill:zk=local.rcggs.com
>
>
> I am able to telnet to zookeeper like so...
>
>
> telnet local.rcggs.com 2181
>
>
> but when i try to connect with squirrel i get this error...
>
>
> java.util.concurrent.ExecutionException: java.lang.RuntimeException:
> java.lang.IllegalStateException: No DrillbitEndpoint can be found
>
> Thanks for your assistance
>
>
>
>
Re: cant connect to drill with SQuriieL
Posted by Aditya <ad...@gmail.com>.
Hi Eric,
This error indicates that the client was able to connect to the specified
ZooKeeper but no DrilBit had registered itself to this instance. Could you
check if
1. DrillBits are running in distributed mode[1], and
2. Configured to use the same ZooKeeper.
If both of these are true, most likely your cluster id is set to a
non-default value, in which case, you may want to use the full JDBC URL,
i.e.
jdbc:drill:zk=<zk_quorum>/drill/<cluster_ID>;schema=<schema_to_use_as_default>
[1]
https://cwiki.apache.org/confluence/display/DRILL/Installing+Drill+in+Distributed+Mode
On Mon, Oct 27, 2014 at 7:24 AM, Perler, Eric <er...@walgreens.com>
wrote:
> Hello
>
>
> Im trying to connect to drill using squirrel
>
>
> i am using this URL...
>
>
> jdbc:drill:zk=local.rcggs.com
>
>
> I am able to telnet to zookeeper like so...
>
>
> telnet local.rcggs.com 2181
>
>
> but when i try to connect with squirrel i get this error...
>
>
> java.util.concurrent.ExecutionException: java.lang.RuntimeException:
> java.lang.IllegalStateException: No DrillbitEndpoint can be found
>
> Thanks for your assistance
>
>
>
>