Did anything change on your system that might indicate why you cannot connect lately?
Thanks. --Robert ________________________________ From: Robert Hou <[email protected]> Sent: Wednesday, May 16, 2018 10:25 AM To: [email protected] 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 <[email protected]> Sent: Wednesday, May 16, 2018 7:27 AM To: [email protected] 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" <[email protected]> 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
