Use Drill 1.10 with the current published ODBC driver, there may be some issues with Drill 1.11. Also use Tableau 10.2+ with the Apache Drill connector. This works much better than generic ODBC. Make sure you can connect to Drill via ODBC, use Drill Explorer as example.
Also look at some Drill Best Practices for BI Tools https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools —Andries On Nov 3, 2017, at 12:57 AM, Divya Gehlot <[email protected]<mailto:[email protected]>> wrote: Hi, I am getting protocol disconnected error in tableau. When checked the drill logs I could see below 2017-11-03 07:51:52,798 [BitServer-4] WARN o.a.drill.exec.work.foreman.Foreman - Dropping request to move to COMPLETED state as query is already at CANCELED state (which is terminal). 2017-11-03 07:51:52,798 [BitServer-4] WARN o.a.d.e.w.b.ControlMessageHandler - Dropping request to cancel fragment. 2603e022-e3c1-e5a7-d54f-08e1399b4936:0:0 does not exist. 2017-11-03 07:51:52,805 [BitServer-4] INFO o.a.drill.exec.work.foreman.Foreman - Failure while trying communicate query result to initiating client. This would happen if a client is disconnected before response notice can be sent. org.apache.drill.exec.rpc.RpcException: Failure sending message. at org.apache.drill.exec.rpc.RpcBus.send(RpcBus.java:124) [drill-rpc-1.10.0.jar:1.10.0] at org.apache.drill.exec.rpc.user.UserServer$BitToUserConnection.sendResult(UserServer.java:199) [drill-java-exec-1.10.0.jar:1.10.0] at org.apache.drill.exec.work.foreman.Foreman$ForemanResult.close(Foreman.java:868) [drill-java-exec-1.10.0.jar:1.10.0] at org.apache.drill.exec.work.foreman.Foreman.moveToState(Foreman.java:1001) [drill-java-exec-1.10.0.jar:1.10.0] at org.apache.drill.exec.work.foreman.Foreman.access$2600(Foreman.java:116) [drill-java-exec-1.10.0.jar:1.10.0] at org.apache.drill.exec.work.foreman.Foreman$StateSwitch.processEvent(Foreman.java:1027) [drill-java-exec-1.10.0.jar:1.10.0] As suggested by one of the Drill user I set the rpc: { user: { timeout: 30 } }, When I set above conf then could see the the dashboard is still in loading state while no error log in drill. Appreciate the help to resolve the issue! Thanks, Divya
