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 <r...@mapr.com> wrote: > 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=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" <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&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 > > >
