drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Divya Gehlot <divya.htco...@gmail.com>
Subject Re: Apache Drill and Tableau connectivity issue
Date Sat, 02 Jun 2018 16:53:47 GMT
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 <rhou@mapr.com> wrote:

> Did anything change on your system that might indicate why you cannot
> connect lately?
>
>
> Thanks.
>
>
> --Robert
>
> ________________________________
> From: Robert Hou <rhou@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 <aengelbrecht@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&amp;width=144&amp;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&amp;width=144&amp;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.htconex@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
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message