AnsweredAssumed Answered

Issue connecting to Drill 0.7.0 on MapR 4.0.1 cluster

Question asked by zaheer.shaik on Jan 27, 2015
Latest reply on May 9, 2016 by jromanda
I get the following error while connecting to Drill using SquirrelClient from MacOSX to connect to the Drill installed on a Ubuntu EC2 MapR 4.0.1 with Drill 0.7.0 cluster.

It is a java.nio.channels.UnresolvedAddressException, but I'm not sure why I get that, when I'm able to ping the ZK servers also able to browse the ZK quorum with Hue Zookeeper app.

Any help?

jdbc:drill:zk=ZOOKEEPER_QUORUM/drill/CLUSTER_NAME
username/password: admin/admin

    java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Failure while attempting to connect to Drill.
     at java.util.concurrent.FutureTask.report(FutureTask.java:122)
     at java.util.concurrent.FutureTask.get(FutureTask.java:206)
     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:511)
     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
     at java.lang.Thread.run(Thread.java:744)
    Caused by: java.lang.RuntimeException: java.sql.SQLException: Failure while attempting to connect to Drill.
     at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
     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.sql.SQLException: Failure while attempting to connect to Drill.
     at org.apache.drill.jdbc.DrillConnectionImpl.<init>(DrillConnectionImpl.java:96)
     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)
     ... 7 more
    Caused by: org.apache.drill.exec.rpc.RpcException: Failure connecting to server. Failure of type CONNECTION.
     at org.apache.drill.exec.client.DrillClient$FutureHandler.connectionFailed(DrillClient.java:364)
     at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:161)
     at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:146)
     at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
     at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:567)
     at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:424)
     at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.connect(AbstractNioChannel.java:235)
     at io.netty.channel.DefaultChannelPipeline$HeadContext.connect(DefaultChannelPipeline.java:1029)
     at io.netty.channel.AbstractChannelHandlerContext.invokeConnect(AbstractChannelHandlerContext.java:496)
     at io.netty.channel.AbstractChannelHandlerContext.connect(AbstractChannelHandlerContext.java:481)
     at io.netty.channel.ChannelOutboundHandlerAdapter.connect(ChannelOutboundHandlerAdapter.java:47)
     at io.netty.channel.AbstractChannelHandlerContext.invokeConnect(AbstractChannelHandlerContext.java:496)
     at io.netty.channel.AbstractChannelHandlerContext.connect(AbstractChannelHandlerContext.java:481)
     at io.netty.channel.AbstractChannelHandlerContext.connect(AbstractChannelHandlerContext.java:463)
     at io.netty.channel.DefaultChannelPipeline.connect(DefaultChannelPipeline.java:849)
     at io.netty.channel.AbstractChannel.connect(AbstractChannel.java:202)
     at io.netty.bootstrap.Bootstrap$2.run(Bootstrap.java:165)
     at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:380)
     at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:357)
     at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:116)
     ... 1 more
    Caused by: java.util.concurrent.ExecutionException: java.nio.channels.UnresolvedAddressException
     at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:37)
     at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:152)
     ... 19 more
    Caused by: java.nio.channels.UnresolvedAddressException
     at sun.nio.ch.Net.checkAddress(Net.java:121)
     at sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:617)
     at io.netty.channel.socket.nio.NioSocketChannel.doConnect(NioSocketChannel.java:193)
     at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.connect(AbstractNioChannel.java:199)
     ... 14 more

Outcomes