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.deiudici...@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.deiudici...@legalmail.it>