You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Divya Gehlot <di...@gmail.com> on 2018/05/16 04:21:45 UTC
Apache Drill and Tableau connectivity issue
Hi,
I am facing tableau and Apache Drill connectivity issue recently , which
was all working fine for long time (for more than 9+ months )
I did tested couple of scenarios, sharing below :
*Driver Version* - MapR Driver Version 1.3.0
*Scenario 1 : Tableau 10.2 - Apche Drill Connection - handshake timeout 180
in system dsn*
*Error :*
The connection to the data source might have been lost.
ExternalProtocol::PipeMessageSource::ReadByte s: Communication with the
Tableau Protocol Server process was lost.
* Scenario 2 : Tableaus 10.2 - Other ODBC Driver - Driver - advance
properties empty *
*Error :*
The protocol is disconnected!
Unable to connect to the server "MapR Drill ODBC Driver". Check that the
server is running and that you have access privileges to the requested
database.
* Scenario 3 :Tableau 10.2 - Other ODBC Driver - DSN - handshake timeout
=180*
*Error :*
Able to connect
* Scenario 4 : Tableau 10.4 - Apache Drill Connector - Direct Connection-
data.xxx.com <http://data.xxx.com>*
*Error*:
The protocol is disconnected!
Unable to connect to the server "data.jll.com". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 5 : Tableau 10.4 - Apache Drill Connector - Direct Connection -
xx.xx.xx.x(IP address)*
*Error Message :*
The protocol is disconnected!
Unable to connect to the server "10.xx.xx.x". Check that the server is
running and that you have access privileges to the requested database.
*Scenario 6 : Tableau 10.4 - Apache Drill Connector - Zookeeper Quorum*
[MapR][Drill] (10) Failure occurred while trying to connect to
zk=10.xx.xx:5181,10.xx.xx.x:5181,10.xx.xx.x:5181/drill/mapr_prod-drillbits
Unable to connect to the server
"10.xx.xx.x:5181,10.xx.xx.x:5181,10.xx.xx.x:5181". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 7 : Tableau 10.4 - Other ODBC Driver -DSN connection - handshake
timeout = 180 *
able to Connect !
* Scenario 8 : Tableaus 10.4 - Other ODBC Driver - Driver - advance
properties empty *
The protocol is disconnected!
Generic ODBC requires additional configuration. The driver and DSN (data
source name) must be installed and configured to match the connection.
Unable to connect to the server "MapR Drill ODBC Driver". Check that the
server is running and that you have access privileges to the requested
database.
* Scenario 9 : Tableau 2018.1 - Apache Drill Connector - Direct connection
-data.xxx.com <http://data.xxx.com>*
An error occurred while communicating with Apache Drill.
The connection to the data source might have been lost.
The protocol is disconnected!
Unable to connect to the server "data.jll.com". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 10 : Tableau 2018.1 - Apache Drill Connector - Zookeeper Quorum*
An error occurred while communicating with Apache Drill.
The connection to the data source might have been lost.
The protocol is disconnected!
Unable to connect to the server
"10.xx.xx.x:5181,10.xx.xx.5:5181,10.xx.xx.x:5181". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 11: Tableau 2018.1 - Other ODBC Driver -DSN connection -
handshake timeout = 180 *
able to connect !
Appreciate the help !
Thanks,
Divya
Re: Apache Drill and Tableau connectivity issue
Posted by Divya Gehlot <di...@gmail.com>.
Yes only change which I hapened was OS patching which is monthly schedule
activity.
Thanks,
Divya
On Thu, 17 May 2018 at 2:32 AM, Robert Hou <rh...@mapr.com> wrote:
> Did anything change on your system that might indicate why you cannot
> connect lately?
>
>
> Thanks.
>
>
> --Robert
>
> ________________________________
> From: Robert Hou <rh...@mapr.com>
> Sent: Wednesday, May 16, 2018 10:25 AM
> To: user@drill.apache.org
> Subject: Re: Apache Drill and Tableau connectivity issue
>
> MapR Driver Version 1.3.0 seems quite old. It may not work with recent
> versions of Drill. What version of Drill are you running?
>
>
> Thanks.
>
>
> --Robert
>
> ________________________________
> From: Andries Engelbrecht <ae...@mapr.com>
> Sent: Wednesday, May 16, 2018 7:27 AM
> To: user@drill.apache.org
> Subject: Re: Apache Drill and Tableau connectivity issue
>
> I have worked with the following combinations and not had an issue.
>
> ODBC v1.3.16 - you may want to consider upgrading to it.
>
> Apache Drill on MapR v 1.10, 1.11 & 1.12 (just did a little with 1.13 but
> not had issues).
>
> All the Drill storage plugins are healthy and working properly. All the
> Drill Views are well defined and working properly.
> You can do a quick test by running "show schemas" to see if it is
> responsive and returns the results quickly.
>
> Tableau 10.2, 10.5 and 2018.1 using the Apache Drill data connection.
> All of them work fine in my case with the above Drill versions and ODBC
> driver mentioned.
>
> Make sure nothing got flaky in you Drill env. I did a quick guide for
> Drill with BI Tools that has been helpful for many users.
>
> https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools
> [
> https://community.mapr.com/api/core/v3/people/6251/avatar?a=1280&width=144&height=144
> ]<
> https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools
> >
>
> Drill Best Practices for BI and Analytical Tools | MapR ...<
> https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools
> >
> community.mapr.com
> Below are a number of best practices to optimize the overall experience
> for analysts and users when using Business Intelligence and Analytical
> tools with
>
>
>
> [
> https://community.mapr.com/api/core/v3/people/6251/avatar?a=1280&width=144&height=144
> ]<
> https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools
> >
>
> Drill Best Practices for BI and Analytical Tools | MapR ...<
> https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools
> >
> community.mapr.com
> Below are a number of best practices to optimize the overall experience
> for analysts and users when using Business Intelligence and Analytical
> tools with
>
>
>
>
>
> --Andries
>
>
>
>
> On 5/15/18, 9:22 PM, "Divya Gehlot" <di...@gmail.com> wrote:
>
> Hi,
> I am facing tableau and Apache Drill connectivity issue recently ,
> which
> was all working fine for long time (for more than 9+ months )
>
>
> I did tested couple of scenarios, sharing below :
>
> *Driver Version* - MapR Driver Version 1.3.0
>
> *Scenario 1 : Tableau 10.2 - Apche Drill Connection - handshake
> timeout 180
> in system dsn*
> *Error :*
> The connection to the data source might have been lost.
> ExternalProtocol::PipeMessageSource::ReadByte s: Communication with the
> Tableau Protocol Server process was lost.
>
>
> * Scenario 2 : Tableaus 10.2 - Other ODBC Driver - Driver - advance
> properties empty *
> *Error :*
> The protocol is disconnected!
> Unable to connect to the server "MapR Drill ODBC Driver". Check that
> the
> server is running and that you have access privileges to the requested
> database.
>
>
> * Scenario 3 :Tableau 10.2 - Other ODBC Driver - DSN - handshake
> timeout
> =180*
> *Error :*
> Able to connect
>
>
> * Scenario 4 : Tableau 10.4 - Apache Drill Connector - Direct
> Connection-
> data.xxx.com <
> https://urldefense.proofpoint.com/v2/url?u=http-3A__data.xxx.com&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU&m=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY&s=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes&e=
> >*
> *Error*:
> The protocol is disconnected!
> Unable to connect to the server "data.jll.com". Check that the server
> is
> running and that you have access privileges to the requested database.
>
>
> * Scenario 5 : Tableau 10.4 - Apache Drill Connector - Direct
> Connection -
> xx.xx.xx.x(IP address)*
> *Error Message :*
> The protocol is disconnected!
> Unable to connect to the server "10.xx.xx.x". Check that the server is
> running and that you have access privileges to the requested database.
>
>
> *Scenario 6 : Tableau 10.4 - Apache Drill Connector - Zookeeper Quorum*
> [MapR][Drill] (10) Failure occurred while trying to connect to
>
> zk=10.xx.xx:5181,10.xx.xx.x:5181,10.xx.xx.x:5181/drill/mapr_prod-drillbits
> Unable to connect to the server
> "10.xx.xx.x:5181,10.xx.xx.x:5181,10.xx.xx.x:5181". Check that the
> server is
> running and that you have access privileges to the requested database.
>
>
> * Scenario 7 : Tableau 10.4 - Other ODBC Driver -DSN connection -
> handshake
> timeout = 180 *
> able to Connect !
>
>
> * Scenario 8 : Tableaus 10.4 - Other ODBC Driver - Driver - advance
> properties empty *
>
> The protocol is disconnected!
> Generic ODBC requires additional configuration. The driver and DSN
> (data
> source name) must be installed and configured to match the connection.
> Unable to connect to the server "MapR Drill ODBC Driver". Check that
> the
> server is running and that you have access privileges to the requested
> database.
>
>
>
> * Scenario 9 : Tableau 2018.1 - Apache Drill Connector - Direct
> connection
> -data.xxx.com <
> https://urldefense.proofpoint.com/v2/url?u=http-3A__data.xxx.com&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU&m=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY&s=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes&e=
> >*
> An error occurred while communicating with Apache Drill.
>
> The connection to the data source might have been lost.
> The protocol is disconnected!
> Unable to connect to the server "data.jll.com". Check that the server
> is
> running and that you have access privileges to the requested database.
>
>
>
> * Scenario 10 : Tableau 2018.1 - Apache Drill Connector - Zookeeper
> Quorum*
>
> An error occurred while communicating with Apache Drill.
>
> The connection to the data source might have been lost.
> The protocol is disconnected!
> Unable to connect to the server
> "10.xx.xx.x:5181,10.xx.xx.5:5181,10.xx.xx.x:5181". Check that the
> server is
> running and that you have access privileges to the requested database.
>
>
>
> * Scenario 11: Tableau 2018.1 - Other ODBC Driver -DSN connection -
> handshake timeout = 180 *
> able to connect !
>
> Appreciate the help !
>
> Thanks,
> Divya
>
>
>
Re: Apache Drill and Tableau connectivity issue
Posted by Robert Hou <rh...@mapr.com>.
Did anything change on your system that might indicate why you cannot connect lately?
Thanks.
--Robert
________________________________
From: Robert Hou <rh...@mapr.com>
Sent: Wednesday, May 16, 2018 10:25 AM
To: user@drill.apache.org
Subject: Re: Apache Drill and Tableau connectivity issue
MapR Driver Version 1.3.0 seems quite old. It may not work with recent versions of Drill. What version of Drill are you running?
Thanks.
--Robert
________________________________
From: Andries Engelbrecht <ae...@mapr.com>
Sent: Wednesday, May 16, 2018 7:27 AM
To: user@drill.apache.org
Subject: Re: Apache Drill and Tableau connectivity issue
I have worked with the following combinations and not had an issue.
ODBC v1.3.16 - you may want to consider upgrading to it.
Apache Drill on MapR v 1.10, 1.11 & 1.12 (just did a little with 1.13 but not had issues).
All the Drill storage plugins are healthy and working properly. All the Drill Views are well defined and working properly.
You can do a quick test by running "show schemas" to see if it is responsive and returns the results quickly.
Tableau 10.2, 10.5 and 2018.1 using the Apache Drill data connection.
All of them work fine in my case with the above Drill versions and ODBC driver mentioned.
Make sure nothing got flaky in you Drill env. I did a quick guide for Drill with BI Tools that has been helpful for many users.
https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools
[https://community.mapr.com/api/core/v3/people/6251/avatar?a=1280&width=144&height=144]<https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools>
Drill Best Practices for BI and Analytical Tools | MapR ...<https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools>
community.mapr.com
Below are a number of best practices to optimize the overall experience for analysts and users when using Business Intelligence and Analytical tools with
[https://community.mapr.com/api/core/v3/people/6251/avatar?a=1280&width=144&height=144]<https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools>
Drill Best Practices for BI and Analytical Tools | MapR ...<https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools>
community.mapr.com
Below are a number of best practices to optimize the overall experience for analysts and users when using Business Intelligence and Analytical tools with
--Andries
On 5/15/18, 9:22 PM, "Divya Gehlot" <di...@gmail.com> wrote:
Hi,
I am facing tableau and Apache Drill connectivity issue recently , which
was all working fine for long time (for more than 9+ months )
I did tested couple of scenarios, sharing below :
*Driver Version* - MapR Driver Version 1.3.0
*Scenario 1 : Tableau 10.2 - Apche Drill Connection - handshake timeout 180
in system dsn*
*Error :*
The connection to the data source might have been lost.
ExternalProtocol::PipeMessageSource::ReadByte s: Communication with the
Tableau Protocol Server process was lost.
* Scenario 2 : Tableaus 10.2 - Other ODBC Driver - Driver - advance
properties empty *
*Error :*
The protocol is disconnected!
Unable to connect to the server "MapR Drill ODBC Driver". Check that the
server is running and that you have access privileges to the requested
database.
* Scenario 3 :Tableau 10.2 - Other ODBC Driver - DSN - handshake timeout
=180*
*Error :*
Able to connect
* Scenario 4 : Tableau 10.4 - Apache Drill Connector - Direct Connection-
data.xxx.com <https://urldefense.proofpoint.com/v2/url?u=http-3A__data.xxx.com&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU&m=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY&s=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes&e=>*
*Error*:
The protocol is disconnected!
Unable to connect to the server "data.jll.com". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 5 : Tableau 10.4 - Apache Drill Connector - Direct Connection -
xx.xx.xx.x(IP address)*
*Error Message :*
The protocol is disconnected!
Unable to connect to the server "10.xx.xx.x". Check that the server is
running and that you have access privileges to the requested database.
*Scenario 6 : Tableau 10.4 - Apache Drill Connector - Zookeeper Quorum*
[MapR][Drill] (10) Failure occurred while trying to connect to
zk=10.xx.xx:5181,10.xx.xx.x:5181,10.xx.xx.x:5181/drill/mapr_prod-drillbits
Unable to connect to the server
"10.xx.xx.x:5181,10.xx.xx.x:5181,10.xx.xx.x:5181". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 7 : Tableau 10.4 - Other ODBC Driver -DSN connection - handshake
timeout = 180 *
able to Connect !
* Scenario 8 : Tableaus 10.4 - Other ODBC Driver - Driver - advance
properties empty *
The protocol is disconnected!
Generic ODBC requires additional configuration. The driver and DSN (data
source name) must be installed and configured to match the connection.
Unable to connect to the server "MapR Drill ODBC Driver". Check that the
server is running and that you have access privileges to the requested
database.
* Scenario 9 : Tableau 2018.1 - Apache Drill Connector - Direct connection
-data.xxx.com <https://urldefense.proofpoint.com/v2/url?u=http-3A__data.xxx.com&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU&m=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY&s=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes&e=>*
An error occurred while communicating with Apache Drill.
The connection to the data source might have been lost.
The protocol is disconnected!
Unable to connect to the server "data.jll.com". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 10 : Tableau 2018.1 - Apache Drill Connector - Zookeeper Quorum*
An error occurred while communicating with Apache Drill.
The connection to the data source might have been lost.
The protocol is disconnected!
Unable to connect to the server
"10.xx.xx.x:5181,10.xx.xx.5:5181,10.xx.xx.x:5181". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 11: Tableau 2018.1 - Other ODBC Driver -DSN connection -
handshake timeout = 180 *
able to connect !
Appreciate the help !
Thanks,
Divya
Re: Apache Drill and Tableau connectivity issue
Posted by Robert Hou <rh...@mapr.com>.
MapR Driver Version 1.3.0 seems quite old. It may not work with recent versions of Drill. What version of Drill are you running?
Thanks.
--Robert
________________________________
From: Andries Engelbrecht <ae...@mapr.com>
Sent: Wednesday, May 16, 2018 7:27 AM
To: user@drill.apache.org
Subject: Re: Apache Drill and Tableau connectivity issue
I have worked with the following combinations and not had an issue.
ODBC v1.3.16 - you may want to consider upgrading to it.
Apache Drill on MapR v 1.10, 1.11 & 1.12 (just did a little with 1.13 but not had issues).
All the Drill storage plugins are healthy and working properly. All the Drill Views are well defined and working properly.
You can do a quick test by running "show schemas" to see if it is responsive and returns the results quickly.
Tableau 10.2, 10.5 and 2018.1 using the Apache Drill data connection.
All of them work fine in my case with the above Drill versions and ODBC driver mentioned.
Make sure nothing got flaky in you Drill env. I did a quick guide for Drill with BI Tools that has been helpful for many users.
https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools
[https://community.mapr.com/api/core/v3/people/6251/avatar?a=1280&width=144&height=144]<https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools>
Drill Best Practices for BI and Analytical Tools | MapR ...<https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools>
community.mapr.com
Below are a number of best practices to optimize the overall experience for analysts and users when using Business Intelligence and Analytical tools with
--Andries
On 5/15/18, 9:22 PM, "Divya Gehlot" <di...@gmail.com> wrote:
Hi,
I am facing tableau and Apache Drill connectivity issue recently , which
was all working fine for long time (for more than 9+ months )
I did tested couple of scenarios, sharing below :
*Driver Version* - MapR Driver Version 1.3.0
*Scenario 1 : Tableau 10.2 - Apche Drill Connection - handshake timeout 180
in system dsn*
*Error :*
The connection to the data source might have been lost.
ExternalProtocol::PipeMessageSource::ReadByte s: Communication with the
Tableau Protocol Server process was lost.
* Scenario 2 : Tableaus 10.2 - Other ODBC Driver - Driver - advance
properties empty *
*Error :*
The protocol is disconnected!
Unable to connect to the server "MapR Drill ODBC Driver". Check that the
server is running and that you have access privileges to the requested
database.
* Scenario 3 :Tableau 10.2 - Other ODBC Driver - DSN - handshake timeout
=180*
*Error :*
Able to connect
* Scenario 4 : Tableau 10.4 - Apache Drill Connector - Direct Connection-
data.xxx.com <https://urldefense.proofpoint.com/v2/url?u=http-3A__data.xxx.com&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU&m=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY&s=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes&e=>*
*Error*:
The protocol is disconnected!
Unable to connect to the server "data.jll.com". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 5 : Tableau 10.4 - Apache Drill Connector - Direct Connection -
xx.xx.xx.x(IP address)*
*Error Message :*
The protocol is disconnected!
Unable to connect to the server "10.xx.xx.x". Check that the server is
running and that you have access privileges to the requested database.
*Scenario 6 : Tableau 10.4 - Apache Drill Connector - Zookeeper Quorum*
[MapR][Drill] (10) Failure occurred while trying to connect to
zk=10.xx.xx:5181,10.xx.xx.x:5181,10.xx.xx.x:5181/drill/mapr_prod-drillbits
Unable to connect to the server
"10.xx.xx.x:5181,10.xx.xx.x:5181,10.xx.xx.x:5181". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 7 : Tableau 10.4 - Other ODBC Driver -DSN connection - handshake
timeout = 180 *
able to Connect !
* Scenario 8 : Tableaus 10.4 - Other ODBC Driver - Driver - advance
properties empty *
The protocol is disconnected!
Generic ODBC requires additional configuration. The driver and DSN (data
source name) must be installed and configured to match the connection.
Unable to connect to the server "MapR Drill ODBC Driver". Check that the
server is running and that you have access privileges to the requested
database.
* Scenario 9 : Tableau 2018.1 - Apache Drill Connector - Direct connection
-data.xxx.com <https://urldefense.proofpoint.com/v2/url?u=http-3A__data.xxx.com&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU&m=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY&s=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes&e=>*
An error occurred while communicating with Apache Drill.
The connection to the data source might have been lost.
The protocol is disconnected!
Unable to connect to the server "data.jll.com". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 10 : Tableau 2018.1 - Apache Drill Connector - Zookeeper Quorum*
An error occurred while communicating with Apache Drill.
The connection to the data source might have been lost.
The protocol is disconnected!
Unable to connect to the server
"10.xx.xx.x:5181,10.xx.xx.5:5181,10.xx.xx.x:5181". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 11: Tableau 2018.1 - Other ODBC Driver -DSN connection -
handshake timeout = 180 *
able to connect !
Appreciate the help !
Thanks,
Divya
Re: Apache Drill and Tableau connectivity issue
Posted by Andries Engelbrecht <ae...@mapr.com>.
I have worked with the following combinations and not had an issue.
ODBC v1.3.16 - you may want to consider upgrading to it.
Apache Drill on MapR v 1.10, 1.11 & 1.12 (just did a little with 1.13 but not had issues).
All the Drill storage plugins are healthy and working properly. All the Drill Views are well defined and working properly.
You can do a quick test by running "show schemas" to see if it is responsive and returns the results quickly.
Tableau 10.2, 10.5 and 2018.1 using the Apache Drill data connection.
All of them work fine in my case with the above Drill versions and ODBC driver mentioned.
Make sure nothing got flaky in you Drill env. I did a quick guide for Drill with BI Tools that has been helpful for many users.
https://community.mapr.com/community/exchange/blog/2017/01/25/drill-best-practices-for-bi-and-analytical-tools
--Andries
On 5/15/18, 9:22 PM, "Divya Gehlot" <di...@gmail.com> wrote:
Hi,
I am facing tableau and Apache Drill connectivity issue recently , which
was all working fine for long time (for more than 9+ months )
I did tested couple of scenarios, sharing below :
*Driver Version* - MapR Driver Version 1.3.0
*Scenario 1 : Tableau 10.2 - Apche Drill Connection - handshake timeout 180
in system dsn*
*Error :*
The connection to the data source might have been lost.
ExternalProtocol::PipeMessageSource::ReadByte s: Communication with the
Tableau Protocol Server process was lost.
* Scenario 2 : Tableaus 10.2 - Other ODBC Driver - Driver - advance
properties empty *
*Error :*
The protocol is disconnected!
Unable to connect to the server "MapR Drill ODBC Driver". Check that the
server is running and that you have access privileges to the requested
database.
* Scenario 3 :Tableau 10.2 - Other ODBC Driver - DSN - handshake timeout
=180*
*Error :*
Able to connect
* Scenario 4 : Tableau 10.4 - Apache Drill Connector - Direct Connection-
data.xxx.com <https://urldefense.proofpoint.com/v2/url?u=http-3A__data.xxx.com&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU&m=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY&s=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes&e=>*
*Error*:
The protocol is disconnected!
Unable to connect to the server "data.jll.com". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 5 : Tableau 10.4 - Apache Drill Connector - Direct Connection -
xx.xx.xx.x(IP address)*
*Error Message :*
The protocol is disconnected!
Unable to connect to the server "10.xx.xx.x". Check that the server is
running and that you have access privileges to the requested database.
*Scenario 6 : Tableau 10.4 - Apache Drill Connector - Zookeeper Quorum*
[MapR][Drill] (10) Failure occurred while trying to connect to
zk=10.xx.xx:5181,10.xx.xx.x:5181,10.xx.xx.x:5181/drill/mapr_prod-drillbits
Unable to connect to the server
"10.xx.xx.x:5181,10.xx.xx.x:5181,10.xx.xx.x:5181". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 7 : Tableau 10.4 - Other ODBC Driver -DSN connection - handshake
timeout = 180 *
able to Connect !
* Scenario 8 : Tableaus 10.4 - Other ODBC Driver - Driver - advance
properties empty *
The protocol is disconnected!
Generic ODBC requires additional configuration. The driver and DSN (data
source name) must be installed and configured to match the connection.
Unable to connect to the server "MapR Drill ODBC Driver". Check that the
server is running and that you have access privileges to the requested
database.
* Scenario 9 : Tableau 2018.1 - Apache Drill Connector - Direct connection
-data.xxx.com <https://urldefense.proofpoint.com/v2/url?u=http-3A__data.xxx.com&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU&m=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY&s=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes&e=>*
An error occurred while communicating with Apache Drill.
The connection to the data source might have been lost.
The protocol is disconnected!
Unable to connect to the server "data.jll.com". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 10 : Tableau 2018.1 - Apache Drill Connector - Zookeeper Quorum*
An error occurred while communicating with Apache Drill.
The connection to the data source might have been lost.
The protocol is disconnected!
Unable to connect to the server
"10.xx.xx.x:5181,10.xx.xx.5:5181,10.xx.xx.x:5181". Check that the server is
running and that you have access privileges to the requested database.
* Scenario 11: Tableau 2018.1 - Other ODBC Driver -DSN connection -
handshake timeout = 180 *
able to connect !
Appreciate the help !
Thanks,
Divya