Hi Divya, Normally 5 second default for the client server handshake is enough for most setup. Since you mentioned that this incident is out of the ordinary, I would double check the health of the drillbit and the state of the server environment.
------------------ If you need to modify the handshake timeout value ------------------ You can set the HandshakeTimeout value in the AdvancedProperties field in the ODBC driver. The default value is 5 seconds. https://drill.apache.org/docs/odbc-configuration-reference/ Are you connecting to drillbit using Tableau's " Other Databases (ODBC)" connector or the "Apache Drill" connector? If you are using the "Other Databases (ODBC)" connector in Tableau: And connecting via DSN: Please open the ODBC Administrator (make sure it’s the correct bitness) and click on the "System DSN" tab. Then, click on "MapR Drill" and then click the "Configure..." button on the right. Then, please modify the default HandshakeTimeout value from 5 seconds to your preference. Then, click the ok button to save the setting. And connecting via Driver: A configuration popup window should appear when you try to connect. Add HandshakeTimeout=<value> in the AdvancedProperties field. If you are using the Apache Drill connector in Tableau: Then you would need to create a custom settings file for Tableau to pick up this information. Best regards, Rob -----Original Message----- From: Divya Gehlot <[email protected]> Sent: Wednesday, May 2, 2018 12:11 AM To: [email protected] Subject: tableau drill connection - handshake time out error Hi , I am connecting Apache Drill through Tableau 10.X version . I was able to connect successfully for this while Now all of sudden I am getting handshake timeout error when I try connect drill through tableau. Error : [MapR][Drill] (40) Handshake timed out (HandshakeTimeout=5) while trying to connect to local=xx.xx.xx.x:31010. Check whether Drillbit is running in a healthy state or increase the timeout. I try adding below configurations in drill-overide.conf also #Optional handshakeTimeout in milliseconds. Default is 10000 ms (10 seconds) handshakeTimeout: 60000, but it didnt help. Appreciate the help ! Thanks, Divya
