Hi, I don't see any entry in drillbit.log and drillbit.out file when I try log in through tableau. I tried with Tableau desktop(10.2) and tableau Server (10.5).None worked for me . Its the 3 node MapR 5.2 having Drill 1.10.0 version .
Thanks, Divya On 4 May 2018 at 01:30, Sorabh Hamirwasia <[email protected]> wrote: > 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 <[email protected]> > Sent: Wednesday, May 2, 2018 9:23:45 PM > To: [email protected] > 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 <[email protected]> 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" <[email protected]> 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 <[email protected]> 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 <[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 > > > > > > > > > >
