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 10000 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

[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=<hostname>:31010


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


--Andries

Post by ignazio deiudicibus
Hi all,
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
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 10000 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)
jdbc:drill:zk=local:2181
tried also
jdbc:drill:zk=localhost:2181
jdbc:drill:zk=127.0.0.1:2181
drill.exec: {
cluster-id: "drillbits1",
zk.connect: "locahost:2181"
}
what's wrong with it?
Thank a lot
regards
I
--
ignazio de iudicibus
mobile [phone]

[ignazio deiudicibus]

It works.
Thanks a lot!



Il 16/Dic/2016 16:02, "Andries Engelbrecht" <***@maprtech.com> 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=<hostname>:31010


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


--Andries

Post by ignazio deiudicibus
Hi all,
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
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 10000 milliseconds.
at
oadd.org.apache.drill.exec.coord.zk.ZKClusterCoordinator.

start(ZKClusterCoordinator.java:123)

Post by ignazio deiudicibus
at
oadd.org.apache.drill.exec.client.DrillClient.connect(

DrillClient.java:243)

Post by ignazio deiudicibus
jdbc:drill:zk=local:2181
tried also
jdbc:drill:zk=localhost:2181
jdbc:drill:zk=127.0.0.1:2181
drill.exec: {
cluster-id: "drillbits1",
zk.connect: "locahost:2181"
}
what's wrong with it?
Thank a lot
regards
I
--
ignazio de iudicibus
mobile [phone]