Check the following: -can you connect using sqlline to the ZK? -can the client running SQuirreL resolve the ZK node name, use the ZK node name instead of the IP address in the connection string.
--Andries > On Jan 5, 2015, at 7:56 PM, Carol McDonald <[email protected]> wrote: > > here is the stack trace, I am using the latest 0.7 jdbc jar , with the > mapr drill sandbox, with this url > > jdbc:drill:zk=192.168.110.133:5181/drill/drillbits1;schema=hive > > java.util.concurrent.ExecutionException: java.lang.RuntimeException: > java.lang.IllegalStateException: No DrillbitEndpoint can be found > at java.util.concurrent.FutureTask.report(FutureTask.java:122) > at java.util.concurrent.FutureTask.get(FutureTask.java:202) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.lang.RuntimeException: java.lang.IllegalStateException: No > DrillbitEndpoint can be found > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:175) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104) > ... 5 more > Caused by: java.lang.IllegalStateException: No DrillbitEndpoint can be found > at com.google.common.base.Preconditions.checkState(Preconditions.java:149) > at org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:168) > at > org.apache.drill.jdbc.DrillConnectionImpl.<init>(DrillConnectionImpl.java:93) > at > org.apache.drill.jdbc.DrillJdbc41Factory$DrillJdbc41Connection.<init>(DrillJdbc41Factory.java:88) > at > org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:57) > at > org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:43) > at org.apache.drill.jdbc.DrillFactory.newConnection(DrillFactory.java:51) > at > net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126) > at > net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167) > > On Mon, Jan 5, 2015 at 10:54 PM, Carol McDonald <[email protected]> > wrote: > >> I am having problems getting JDBC to Access Apache Drill from SQuirreL >> following these instructions >> >> https://cwiki.apache.org/confluence/display/DRILL/Using+JDBC+to+Access+Apache+Drill+from+SQuirreL >> >> I get the following error : Unexpected Error occurred attempting to open >> an SQL connection. >> >> >>
