Re: tableau drill connection - handshake time out error

[Divya Gehlot]

Hi Sorabh,
On the machine where Tableau Desktop is installed , I am able to login
through Drill Explorer .
Neither able to login throug tableau desktop nor tableau server.
I did enabled ODBC tracing and here is link[1] of the tracing log .

Here is the error which I could see at tableau side
[MapR][Drill] (40) Handshake timed out (HandshakeTimeout=5) while trying to
connect to local=xxx.xxx.xxx:31010.[2] Check whether Drillbit is running in
a healthy state or increase the timeout.
Unable to connect to the server ".xxx.xxx".[2] Check that the server is
running and that you have access privileges to the requested database.


[1] https://pastebin.com/kcwCsPDa
[2]Removed the Domain name.

Thanks,
Divya

On 9 May 2018 at 00:55, Sorabh Hamirwasia  wrote:

> Hi Divya,
>
> If you are seeing no logs on server side (considering logging is not
> disabled) that means issue is on the client side setup. It can be either on
> Tableau or with the ODBC driver itself. In your previous thread you
> mentioned the setup was working fine when using Drill Explorer. If
> you were using the same driver then that points to Tableau side of issue.
>
> Can you provide error which you are seeing on client side ? Also can
> you try enable logging [1] for ODBC driver to see if it provides any
> other information.
>
>
> [1]: https://docs.microsoft.com/en-us/sql/odbc/admin/
> setting-tracing-options?view=sql-server-2017
>
>
> Thanks,
> Sorabh
>
>
>
> --
> *From:* Divya Gehlot 
> *Sent:* Tuesday, May 8, 2018 3:05 AM
> *To:* user@drill.apache.org; Sorabh Hamirwasia
>
> *Subject:* Re: tableau drill connection - handshake time out error
>
> 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  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 
> 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  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"  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  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.
> > > 

Re: RE: Not Able to Query Part files Using Drill

[Paul Rogers]

Hi Tilak,

Drill's format matching mechanism uses the file suffix (only). Drill has no way 
to match on any other part of the name. So, in order to get Drill to read your 
file, you either need a file suffix that matches a format config, or define the 
default config to be the one you want. That is, where you have

      "defaultInputFormat": null,


Try changing it to

      "defaultInputFormat": "csv",


Caveat: I've not tested this just now, but I believe I've used this trick in 
the past...

Thanks,
- Paul

 

On Tuesday, May 8, 2018, 6:06:26 AM PDT, Surneni Tilak 
 wrote:  
 
 Hi Team,

I am trying to query the part files which are of type text(Encoding format 
ASCII ) but with no file extension. Those part files are generated using  
Sparkbench suite. 

Please find the below error message:

Query Failed: An Error Occurred
org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: From 
line 1, column 15 to line 1, column 17: Table 
'dfs./mapr/mycluster/NSC-TEST/large_inputs01/PageRank/Input328141MB/part-00219' 
not found SQL Query null [Error Id: b15a3b3b-3a32-493c-a2b7-1490e1f00d3c on 
node1:31010]


My workspace details:

{
  "type": "file",
  "enabled": true,
  "connection": "file:///",
  "config": null,
  "workspaces": {
    "root": {
      "location": "/",
      "writable": false,
      "defaultInputFormat": null,
      "allowAccessOutsideWorkspace": false
    },
    "tmp": {
      "location": "/tmp",
      "writable": true,
      "defaultInputFormat": null,
      "allowAccessOutsideWorkspace": false
    }
  },
  "formats": {
    "psv": {
      "type": "text",
      "extensions": [
        "tbl"
      ],
      "delimiter": "|"
    },
    "csv": {
      "type": "text",
      "extensions": [
        "csv"
      ],
      "delimiter": ","
    },
    "tsv": {
      "type": "text",
      "extensions": [
        "tsv"
      ],
      "delimiter": "\t"
    },
    "httpd": {
      "type": "httpd",
      "logFormat": "%h %t \"%r\" %>s %b \"%{Referer}i\""
    },
    "parquet": {
      "type": "parquet"
    },
    "json": {
      "type": "json",
      "extensions": [
        "json"
      ]
    },
    "pcap": {
      "type": "pcap"
    },
    "avro": {
      "type": "avro"
    },
    "sequencefile": {
      "type": "sequencefile",
      "extensions": [
        "seq"
      ]
    },
    "csvh": {
      "type": "text",
      "extensions": [
        "csvh"
      ],
      "extractHeader": true,
      "delimiter": ","
    }
  }
}




Best regards, 
_
Tilak 

-Original Message-
From: Parth Chandra [mailto:par...@apache.org] 
Sent: Monday, May 7, 2018 6:55 PM
To: user@drill.apache.org
Subject: Re: Not Able to Query Part files Using Drill

What part files are these? Can you share the workspace settings? Also what is 
the detailed error message you're getting.

On Mon, May 7, 2018 at 3:37 AM, Surneni Tilak 
wrote:

> Hi Team,
>
> I am trying to run drill query on part files present in the local file 
> system. But Drill is throwing Table not found error , I think it is 
> not able to identify the file format and giving that error. I have 
> tried to include  default input format option mentioned in the Drill 
> website in my workspace even then same error is repeating.  Please help me on 
> this.
>
> Best regards,
> _
> Tilak
>
>
>
  

Re: Apache Drill Automatically Converts Large Numbers to Exponents

[Paul Rogers]

Hi Peter,

Just to clarify... Internally, Drill stores numbers as FLOAT or DOUBLE. The 
question is how a client displays the numbers. Khurram has listed a number of 
those clients. If you are using a JDBC/ODBC client, then the issue might be in 
the tool using that driver.

For Drill's own client tools, Drill does not support metadata, so there is no 
way to express a preferred display format for your column. Instead, the 
client's own display rules control display.

Thanks,
- Paul

 

On Tuesday, May 8, 2018, 11:04:13 AM PDT, Khurram Faraaz  
wrote:  
 
 Hi Peter,


Where do you see large numbers being represented/displayed as exponents, in 
Drill (and what version of Drill are you on) ?

 1. Do you see that behavior on sqlline prompt ?

 2. Do you see it from a JDBC application ?

 3. Do you see that on Drill's Web UI ?

 4. If you don't see it on the three options above, where is it that you see 
large numbers being represented as exponents ?


Your response to questions above will help us investigate.


Thanks,

Khurram


From: Vova Vysotskyi 
Sent: Tuesday, May 8, 2018 8:44:46 AM
To: user@drill.apache.org
Subject: Re: Apache Drill Automatically Converts Large Numbers to Exponents

Hi Peter,

If the problem is only with displaying the numbers, you may convert it to
the string with the specified format using TO_CHAR(expression, format) UDF.

For more details please see
https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_data-2Dtype-2Dconversion_-23other-2Ddata-2Dtype-2Dconversions=DwIFaQ=cskdkSMqhcnjZxdQVpwTXg=H5JEl9vb-mBIjic10QAbDD2vkUUKAxjO6wZO322RtdI=Ie9zGKXICN7MzxqsC1pm2IVdufd_8Lh-QXKd_u6VU3Y=2f_ECxi0EnA5vpjDq7nGXG9YyswBfUp9QRt_tMO_64Q=

Kind regards,
Volodymyr Vysotskyi


вт, 8 трав. 2018 о 18:36 Peter Edike 
пише:

> Hello everyone,
>
> How can I prevent Apache Drill From Displaying large numers as exponents
> as this is not acceptable for my use case
>
>
> Kind regards
> Peter Edike
>  

Re: Apache Drill Automatically Converts Large Numbers to Exponents

[Khurram Faraaz]

Hi Peter,


Where do you see large numbers being represented/displayed as exponents, in 
Drill (and what version of Drill are you on) ?

 1. Do you see that behavior on sqlline prompt ?

 2. Do you see it from a JDBC application ?

 3. Do you see that on Drill's Web UI ?

 4. If you don't see it on the three options above, where is it that you see 
large numbers being represented as exponents ?


Your response to questions above will help us investigate.


Thanks,

Khurram


From: Vova Vysotskyi 
Sent: Tuesday, May 8, 2018 8:44:46 AM
To: user@drill.apache.org
Subject: Re: Apache Drill Automatically Converts Large Numbers to Exponents

Hi Peter,

If the problem is only with displaying the numbers, you may convert it to
the string with the specified format using TO_CHAR(expression, format) UDF.

For more details please see
https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_data-2Dtype-2Dconversion_-23other-2Ddata-2Dtype-2Dconversions=DwIFaQ=cskdkSMqhcnjZxdQVpwTXg=H5JEl9vb-mBIjic10QAbDD2vkUUKAxjO6wZO322RtdI=Ie9zGKXICN7MzxqsC1pm2IVdufd_8Lh-QXKd_u6VU3Y=2f_ECxi0EnA5vpjDq7nGXG9YyswBfUp9QRt_tMO_64Q=

Kind regards,
Volodymyr Vysotskyi


вт, 8 трав. 2018 о 18:36 Peter Edike 
пише:

> Hello everyone,
>
> How can I prevent Apache Drill From Displaying large numers as exponents
> as this is not acceptable for my use case
>
>
> Kind regards
> Peter Edike
>

Re: permission denied error in drillbit.out

[Sorabh Hamirwasia]

This just means it failed to access the directory /Data/Users/AP/ 
using that MapR file client instance. It can happen if the MapR file client 
instance is created in context of a user who doesn't have read permission for 
that directory. Probably you might have some log before this line stating the 
username also which was trying to access this path.


Thanks,
Sorabh


From: Divya Gehlot 
Sent: Tuesday, May 8, 2018 3:18:04 AM
To: user@drill.apache.org
Subject: permission denied error in drillbit.out

Hi,
I can see below entry in drillbit.out although user has permission.

> 2018-05-08 04:52:37,1456 ERROR JniCommon
> fs/client/fileclient/cc/jni_MapRClient.cc:2572 Thread: 2454 readdirplus
> failed for dir /Data/Users/AP/, error = Permission denied(13)


Can anybody help me interpret above error message?


Thanks,
Divya

Re: tableau drill connection - handshake time out error

[Sorabh Hamirwasia]

Hi Divya,

If you are seeing no logs on server side (considering logging is not disabled) 
that means issue is on the client side setup. It can be either on Tableau or 
with the ODBC driver itself. In your previous thread you mentioned the setup 
was working fine when using Drill Explorer. If you were using the same driver 
then that points to Tableau side of issue.

Can you provide error which you are seeing on client side ? Also can you try 
enable logging [1] for ODBC driver to see if it provides any other information.


[1]: 
https://docs.microsoft.com/en-us/sql/odbc/admin/setting-tracing-options?view=sql-server-2017


Thanks,
Sorabh



From: Divya Gehlot 
Sent: Tuesday, May 8, 2018 3:05 AM
To: user@drill.apache.org; Sorabh Hamirwasia
Subject: Re: tableau drill connection - handshake time out error

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 
> 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 >
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 
> 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" 
> > 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 
> > 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_=DwIFaQ=
> cskdkSMqhcnjZxdQVpwTXg=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU=
> JWJb4hdyVwAb6BMNHqmYIDRzArDhsA6FtipM3pFd_HE=
> TF03KzLjSs9F5UwHg3cjsviPr36hGSYh3tVfjL0H-KQ=
> >
> > 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 

Re: Apache Drill Automatically Converts Large Numbers to Exponents

[Vova Vysotskyi]

Hi Peter,

If the problem is only with displaying the numbers, you may convert it to
the string with the specified format using TO_CHAR(expression, format) UDF.

For more details please see
https://drill.apache.org/docs/data-type-conversion/#other-data-type-conversions

Kind regards,
Volodymyr Vysotskyi


вт, 8 трав. 2018 о 18:36 Peter Edike 
пише:

> Hello everyone,
>
> How can I prevent Apache Drill From Displaying large numers as exponents
> as this is not acceptable for my use case
>
>
> Kind regards
> Peter Edike
>

Apache Drill Automatically Converts Large Numbers to Exponents

[Peter Edike]

Hello everyone,

How can I prevent Apache Drill From Displaying large numers as exponents as 
this is not acceptable for my use case


Kind regards
Peter Edike

RE: Not Able to Query Part files Using Drill

[Surneni Tilak]

Hi Team,

I am trying to query the part files which are of type text(Encoding format 
ASCII ) but with no file extension. Those part files are generated using   
Sparkbench suite. 

Please find the below error message:

Query Failed: An Error Occurred
org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: From 
line 1, column 15 to line 1, column 17: Table 
'dfs./mapr/mycluster/NSC-TEST/large_inputs01/PageRank/Input328141MB/part-00219' 
not found SQL Query null [Error Id: b15a3b3b-3a32-493c-a2b7-1490e1f00d3c on 
node1:31010]


My workspace details:

{
  "type": "file",
  "enabled": true,
  "connection": "file:///",
  "config": null,
  "workspaces": {
"root": {
  "location": "/",
  "writable": false,
  "defaultInputFormat": null,
  "allowAccessOutsideWorkspace": false
},
"tmp": {
  "location": "/tmp",
  "writable": true,
  "defaultInputFormat": null,
  "allowAccessOutsideWorkspace": false
}
  },
  "formats": {
"psv": {
  "type": "text",
  "extensions": [
"tbl"
  ],
  "delimiter": "|"
},
"csv": {
  "type": "text",
  "extensions": [
"csv"
  ],
  "delimiter": ","
},
"tsv": {
  "type": "text",
  "extensions": [
"tsv"
  ],
  "delimiter": "\t"
},
"httpd": {
  "type": "httpd",
  "logFormat": "%h %t \"%r\" %>s %b \"%{Referer}i\""
},
"parquet": {
  "type": "parquet"
},
"json": {
  "type": "json",
  "extensions": [
"json"
  ]
},
"pcap": {
  "type": "pcap"
},
"avro": {
  "type": "avro"
},
"sequencefile": {
  "type": "sequencefile",
  "extensions": [
"seq"
  ]
},
"csvh": {
  "type": "text",
  "extensions": [
"csvh"
  ],
  "extractHeader": true,
  "delimiter": ","
}
  }
}




Best regards, 
_
Tilak 

-Original Message-
From: Parth Chandra [mailto:par...@apache.org] 
Sent: Monday, May 7, 2018 6:55 PM
To: user@drill.apache.org
Subject: Re: Not Able to Query Part files Using Drill

What part files are these? Can you share the workspace settings? Also what is 
the detailed error message you're getting.

On Mon, May 7, 2018 at 3:37 AM, Surneni Tilak 
wrote:

> Hi Team,
>
> I am trying to run drill query on part files present in the local file 
> system. But Drill is throwing Table not found error , I think it is 
> not able to identify the file format and giving that error. I have 
> tried to include  default input format option mentioned in the Drill 
> website in my workspace even then same error is repeating.  Please help me on 
> this.
>
> Best regards,
> _
> Tilak
>
>
>

permission denied error in drillbit.out

[Divya Gehlot]

Hi,
I can see below entry in drillbit.out although user has permission.

> 2018-05-08 04:52:37,1456 ERROR JniCommon
> fs/client/fileclient/cc/jni_MapRClient.cc:2572 Thread: 2454 readdirplus
> failed for dir /Data/Users/AP/, error = Permission denied(13)


Can anybody help me interpret above error message?


Thanks,
Divya

Re: tableau drill connection - handshake time out error

[Divya Gehlot]

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  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 
> 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  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"  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  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_=DwIFaQ=
> > cskdkSMqhcnjZxdQVpwTXg=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU=
> > JWJb4hdyVwAb6BMNHqmYIDRzArDhsA6FtipM3pFd_HE=
> > TF03KzLjSs9F5UwHg3cjsviPr36hGSYh3tVfjL0H-KQ=
> > >
> > > 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= 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 
> > > Sent: Wednesday, May 2, 2018 12:11 AM
> > > To: user@drill.apache.org
> > > Subject: tableau drill