drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andries Engelbrecht <aengelbre...@maprtech.com>
Subject Re: exception when connecting via jdbc i.e. squirrell windows embedded mode
Date Fri, 16 Dec 2016 15:02:04 GMT
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




> On Dec 16, 2016, at 12:48 AM, ignazio deiudicibus <i.deiudicibus@gmail.com> 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 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
> 
> -- 
> ignazio de iudicibus
> mobile +39 3280842455
> 
> <i.deiudicibus@legalmail.it>


Mime
View raw message