Re: Apache Drill and Tableau connectivity issue
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 wrote: > Did anything change on your system that might indicate why you cannot > connect lately? > > > Thanks. > > > --Robert > > > From: Robert Hou > 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 > 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=1280width=144height=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=1280width=144height=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" 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=DwIBaQ=cskdkSMqhcnjZxdQVpwTXg=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes= > >* > *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 privileg
Re: Apache Drill and Tableau connectivity issue
Did anything change on your system that might indicate why you cannot connect lately? Thanks. --Robert From: Robert Hou <r...@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 <aengelbre...@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=1280width=144height=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=1280width=144height=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" <divya.htco...@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=DwIBaQ=cskdkSMqhcnjZxdQVpwTXg=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes=>* *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 runni
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 <aengelbre...@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=1280width=144height=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" <divya.htco...@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=DwIBaQ=cskdkSMqhcnjZxdQVpwTXg=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes=>* *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=DwIBaQ=cskdkSMqhcnjZxdQVpwTXg=Q3Oz5l4W5
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 --Andries On 5/15/18, 9:22 PM, "Divya Gehlot" <divya.htco...@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=DwIBaQ=cskdkSMqhcnjZxdQVpwTXg=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes=>* *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=DwIBaQ=cskdkSMqhcnjZxdQVpwTXg=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU=dVnANXTiIX8O3U77c6cYJjyBwvELzzWHhAwPCzx-cZY=QwDSlSyrQ7IeELCA7Fz-CxRXJUFE-IgGETsIJipNHes=>* 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
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