Hi Divya, Can you please share the error seen on client side and also debug/error logs from server side (from drillbit.log and drillbit.out) ? Also what is the setup of your environment ? Are you using Tableau Server or Desktop version ?
Thanks, Sorabh ________________________________ From: Divya Gehlot <divya.htco...@gmail.com> Sent: Wednesday, May 2, 2018 9:23:45 PM To: user@drill.apache.org Subject: Re: tableau drill connection - handshake time out error Hi , Facing strange issue . Apache Drill is connected to Active directory .I am able to connect apache Drill through Web UI and Drill Explorer using my account,but unable to connect to Apache Drill through Tableau using my account getting handshake error . However If I use some other account to connect through Apache Drill in Tableau , able to connect successfully. What could be the reason that I am unable to connect Apache Drill through Tableau. Has anybody face this issue . I am yet to figure out whether its a Drill issue or Tableau. Appreciate the help ! Thanks, Divya On 2 May 2018 at 22:06, Andries Engelbrecht <aengelbre...@mapr.com> wrote: > Check the health of your storage plugins on the drillbit/server/cluster > side. > Run a show schemas in sqlline on the drillbit and see how long it takes to > get back. > > > --Andries > > On 5/2/18, 3:24 AM, "Divya Gehlot" <divya.htco...@gmail.com> wrote: > > Hi Robert, > Thanks for the response. > It was all working while earlier . I am getting this error past couple > of > days . > As you mentioned check the drill bit health and state of the server > environment . > Which configurations do I need check ? Can you please elaborate more. > I am successfuly able to connevt to Drill through Drill explorer and > through Web UI of Apache Drill . > Earlier I was able to connect Drill through tableau without making > changes > to Drill configurations . > I haven't made any changes to Drill configurations also. > Wondering what triggering handshake error. > > > > Grateful for your help ! > > Thanks, > Divya > > > > On 2 May 2018 at 17:08, Robert Wu <r...@magnitude.com> wrote: > > > 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://urldefense.proofpoint.com/v2/url?u=https-3A__drill. > apache.org_docs_odbc-2Dconfiguration-2Dreference_&d=DwIFaQ&c= > cskdkSMqhcnjZxdQVpwTXg&r=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU&m= > JWJb4hdyVwAb6BMNHqmYIDRzArDhsA6FtipM3pFd_HE&s= > TF03KzLjSs9F5UwHg3cjsviPr36hGSYh3tVfjL0H-KQ&e= > > > > 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 <divya.htco...@gmail.com> > > Sent: Wednesday, May 2, 2018 12:11 AM > > To: user@drill.apache.org > > 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 > > > > >
