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
>
