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" <[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
