Hi Team, I am trying to connect to my drill cluster from tableau using MapR Drill ODBC Driver.
I followed steps given in https://drill.apache.org/docs/using-apache-drill-with-tableau-9-server/ and subsequent links and successfully connected to individual "direct drillbit" reading docs. But when i am trying to connect to "zookeeper quorum" instead of "direct drillbit", i am getting below error on MapR interface : FAILED! [MapR][Drill] (1010) Error occurred while trying to connect: [MapR][Drill] (20) The hostname of '10.x.x.x' cannot be resolved. Please check your DNS setup or connect directly to Drillbit. Please note that since i am giving directly IP(Drill Hosts which are on AWS) so i believe i don't have to maintain DNS entries in host file. Also corresponding zookeeper logs are as follows :- 2016-12-01 18:08:42,541 [myid:3] - INFO [NIOServerCxn.Factory: 0.0.0.0/0.0.0.0:2181:NIOServerCnxnFactory@192] - Accepted socket connection from /192.*.*.*:53159 2016-12-01 18:08:42,543 [myid:3] - WARN [NIOServerCxn.Factory: 0.0.0.0/0.0.0.0:2181:ZooKeeperServer@854] - Connection request from old client /192.*.*.*:53159; will be dropped if server is in r-o mode 2016-12-01 18:08:42,543 [myid:3] - INFO [NIOServerCxn.Factory: 0.0.0.0/0.0.0.0:2181:ZooKeeperServer@900] - Client attempting to establish new session at /192.*.*.*:53159 2016-12-01 18:08:42,546 [myid:3] - INFO [CommitProcessor:3:ZooKeeperServer@645] - Established session 0x358ba2951720006 with negotiated timeout 30000 for client /192.*.*.*:53159 2016-12-01 18:08:42,793 [myid:3] - WARN [NIOServerCxn.Factory: 0.0.0.0/0.0.0.0:2181:NIOServerCnxn@357] - caught end of stream exception EndOfStreamException: Unable to read additional data from client sessionid 0x358ba2951720006, likely client has closed socket at org.apache.zookeeper.server.NIOServerCnxn.doIO(NIOServerCnxn.java:230) at org.apache.zookeeper.server.NIOServerCnxnFactory.run(NIOServerCnxnFactory.java:203) at java.lang.Thread.run(Thread.java:745) 2016-12-01 18:08:42,794 [myid:3] - INFO [NIOServerCxn.Factory: 0.0.0.0/0.0.0.0:2181:NIOServerCnxn@1008] - Closed socket connection for client /192.*.*.*:53159 which had sessionid 0x358ba2951720006 2016-12-01 18:08:42,795 [myid:3] - ERROR [CommitProcessor:3:NIOServerCnxn@178] - Unexpected Exception: java.nio.channels.CancelledKeyException at sun.nio.ch.SelectionKeyImpl.ensureValid(SelectionKeyImpl.java:73) at sun.nio.ch.SelectionKeyImpl.interestOps(SelectionKeyImpl.java:77) at org.apache.zookeeper.server.NIOServerCnxn.sendBuffer(NIOServerCnxn.java:151) at org.apache.zookeeper.server.NIOServerCnxn.sendResponse(NIOServerCnxn.java:1082) at org.apache.zookeeper.server.FinalRequestProcessor.processRequest(FinalRequestProcessor.java:404) at org.apache.zookeeper.server.quorum.CommitProcessor.run(CommitProcessor.java:77) I have gone through this link but this doesn't helped me :- http://stackoverflow.com/questions/30940981/zookeeper-error-cannot-open-channel-to-x-at-election-address Regards, *Anup Tiwari*
