You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Santosh Kulkarni <sa...@gmail.com> on 2016/07/26 04:17:07 UTC

Connecting to Drill ODBC DSN takes exceptionally long time

While connecting Tableau to Drill ODBC DSN, it takes almost 5 minutes to
connect to Drill.I created 2 DSN, one for Zookeeper Quorum and other one
for Direct to drillbit, Both take very long time to connect successfully to
Drill.

Also, after the connection just to open Schema and the tables within the
schema it takes another few minutes. Underlying datasource is Hive.

Any thoughts on what causes this issue?

Thanks,

Santosh

Re: Connecting to Drill ODBC DSN takes exceptionally long time

Posted by Santosh Kulkarni <sa...@gmail.com>.

Thanks Neeraja.
We are using TDC file with the ODBC driver.



On Tue, Jul 26, 2016 at 12:06 AM, Neeraja Rentachintala <
nrentachintala@maprtech.com> wrote:

> Andries did a great job on putting together the material below on this
> topic. This info will be helpful to you to optimize metadata access
> experience from Tableay.
> Additionally make sure you are using the Tableau TDC file that ships with
> Drill ODBC drier.
>
>
> https://community.mapr.com/community/answers/blog/2016/07/20/drill-best-practices-for-bi-and-analytical-tools
>
> -Neeraja
>
> On Mon, Jul 25, 2016 at 9:17 PM, Santosh Kulkarni <
> santoshskulkarni75@gmail.com> wrote:
>
> > While connecting Tableau to Drill ODBC DSN, it takes almost 5 minutes to
> > connect to Drill.I created 2 DSN, one for Zookeeper Quorum and other one
> > for Direct to drillbit, Both take very long time to connect successfully
> to
> > Drill.
> >
> > Also, after the connection just to open Schema and the tables within the
> > schema it takes another few minutes. Underlying datasource is Hive.
> >
> > Any thoughts on what causes this issue?
> >
> > Thanks,
> >
> > Santosh
> >
>

Re: Connecting to Drill ODBC DSN takes exceptionally long time

Posted by Neeraja Rentachintala <nr...@maprtech.com>.

Andries did a great job on putting together the material below on this
topic. This info will be helpful to you to optimize metadata access
experience from Tableay.
Additionally make sure you are using the Tableau TDC file that ships with
Drill ODBC drier.

https://community.mapr.com/community/answers/blog/2016/07/20/drill-best-practices-for-bi-and-analytical-tools

-Neeraja

On Mon, Jul 25, 2016 at 9:17 PM, Santosh Kulkarni <
santoshskulkarni75@gmail.com> wrote:

> While connecting Tableau to Drill ODBC DSN, it takes almost 5 minutes to
> connect to Drill.I created 2 DSN, one for Zookeeper Quorum and other one
> for Direct to drillbit, Both take very long time to connect successfully to
> Drill.
>
> Also, after the connection just to open Schema and the tables within the
> schema it takes another few minutes. Underlying datasource is Hive.
>
> Any thoughts on what causes this issue?
>
> Thanks,
>
> Santosh
>