AnsweredAssumed Answered

Drill JDBC issue inside spark

Question asked by Velumani on Feb 1, 2017
Latest reply on Feb 6, 2017 by aalvarez

HI,

I am facing issue when I am trying to query drill through JDBC inside spark. The same piece code works fine if I run as Java application. I am getting Failure in connecting to Drill: oadd.org.apache.drill.exec.rpc.RpcException: Failure setting up ZK for client.
 

Below is the Exception trace .

2017-01-31 02:10:10,475 WARN [main-SendThread(127.0.0.1:5181)] zookeeper.ClientCnxn: Session 0x0 for server null, unexpected error, closing socket connection and attempting reconnect

 

java.sql.SQLException: Failure in connecting to Drill: oadd.org.apache.drill.exec.rpc.RpcException: Failure setting up ZK for client.
at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:164)
at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:70)
at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
at oadd.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)

Also I am able to connect using sqlline. zookeeper is up and running 

 

Any help ?? 

Outcomes