Re: exception when connecting via jdbc i.e. squirrell windows embedded mode

[ignazio deiudicibus]

It works.
Thanks a lot!



Il 16/Dic/2016 16:02, "Andries Engelbrecht"  ha
scritto:

Connect directly to the drillbit when using an embedded drillbit.

URL will be something like this

jdbc:drill:drillbit=localhost
or
jdbc:drill:drillbit=:31010


Make sure to add the JDBC driver package jar(s) to the CP of the
application.


--Andries




> On Dec 16, 2016, at 12:48 AM, ignazio deiudicibus 
wrote:
>
> Hi all,
>
> I've just installed drill as described here:
>
>
> https://drill.apache.org/docs/drill-in-10-minutes/
>
> and started drill using
> sqlline.bat -u "jdbc:drill:zk=local"
>
> everything is ok, I can query.
> But, I can't connect via jdbc
>
> here it is the exception
>
> java.util.concurrent.ExecutionException: java.lang.RuntimeException:
> java.sql.SQLException: Failure in connecting to Drill:
> oadd.org.apache.drill.exec.rpc.RpcException: Failure setting up ZK for
> client.
>
> ..
>
>
> Caused by: java.io.IOException: Failure to connect to the zookeeper
cluster
> service within the allotted time of 1 milliseconds.
> at
> oadd.org.apache.drill.exec.coord.zk.ZKClusterCoordinator.
start(ZKClusterCoordinator.java:123)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(
DrillClient.java:243)
>
>
> I use this jdbc string:
>
> jdbc:drill:zk=local:2181
>
> tried also
>
> jdbc:drill:zk=localhost:2181
>
> jdbc:drill:zk=127.0.0.1:2181
>
> drill-override is:
>
> drill.exec: {
>  cluster-id: "drillbits1",
>  zk.connect: "locahost:2181"
> }
>
> what's wrong with it?
>
> Thank a lot
> regards
> I
>
> --
> ignazio de iudicibus
> mobile +39 3280842455
>
> 

Re: exception when connecting via jdbc i.e. squirrell windows embedded mode

[Andries Engelbrecht]

Connect directly to the drillbit when using an embedded drillbit. 

URL will be something like this

jdbc:drill:drillbit=localhost
or
jdbc:drill:drillbit=:31010


Make sure to add the JDBC driver package jar(s) to the CP of the application.


--Andries




> On Dec 16, 2016, at 12:48 AM, ignazio deiudicibus  
> wrote:
> 
> Hi all,
> 
> I've just installed drill as described here:
> 
> 
> https://drill.apache.org/docs/drill-in-10-minutes/
> 
> and started drill using
> sqlline.bat -u "jdbc:drill:zk=local"
> 
> everything is ok, I can query.
> But, I can't connect via jdbc
> 
> here it is the exception
> 
> java.util.concurrent.ExecutionException: java.lang.RuntimeException:
> java.sql.SQLException: Failure in connecting to Drill:
> oadd.org.apache.drill.exec.rpc.RpcException: Failure setting up ZK for
> client.
> 
> ..
> 
> 
> Caused by: java.io.IOException: Failure to connect to the zookeeper cluster
> service within the allotted time of 1 milliseconds.
> at
> oadd.org.apache.drill.exec.coord.zk.ZKClusterCoordinator.start(ZKClusterCoordinator.java:123)
> at
> oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:243)
> 
> 
> I use this jdbc string:
> 
> jdbc:drill:zk=local:2181
> 
> tried also
> 
> jdbc:drill:zk=localhost:2181
> 
> jdbc:drill:zk=127.0.0.1:2181
> 
> drill-override is:
> 
> drill.exec: {
>  cluster-id: "drillbits1",
>  zk.connect: "locahost:2181"
> }
> 
> what's wrong with it?
> 
> Thank a lot
> regards
> I
> 
> -- 
> ignazio de iudicibus
> mobile +39 3280842455
> 
> 

exception when connecting via jdbc i.e. squirrell windows embedded mode

[ignazio deiudicibus]

Hi all,

I've just installed drill as described here:


https://drill.apache.org/docs/drill-in-10-minutes/

and started drill using
sqlline.bat -u "jdbc:drill:zk=local"

everything is ok, I can query.
But, I can't connect via jdbc

here it is the exception

java.util.concurrent.ExecutionException: java.lang.RuntimeException:
java.sql.SQLException: Failure in connecting to Drill:
oadd.org.apache.drill.exec.rpc.RpcException: Failure setting up ZK for
client.

..


Caused by: java.io.IOException: Failure to connect to the zookeeper cluster
service within the allotted time of 1 milliseconds.
at
oadd.org.apache.drill.exec.coord.zk.ZKClusterCoordinator.start(ZKClusterCoordinator.java:123)
at
oadd.org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:243)


I use this jdbc string:

jdbc:drill:zk=local:2181

tried also

jdbc:drill:zk=localhost:2181

jdbc:drill:zk=127.0.0.1:2181

drill-override is:

drill.exec: {
  cluster-id: "drillbits1",
  zk.connect: "locahost:2181"
}

what's wrong with it?

Thank a lot
regards
I

-- 
ignazio de iudicibus
mobile +39 3280842455