drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Girish <agir...@apache.org>
Subject Re: Drill taking more time to show output
Date Tue, 21 Feb 2017 21:47:22 GMT
Please upload the profile to a public cloud and share a link to it.

Also, please provide an answer to my other question

> On the same setup, what is the performance you see with Text / Parquet
> files?


On Mon, Feb 20, 2017 at 12:58 PM, Sanjiv Kumar C <sanjivc@ejeeva.com> wrote:

> Query Profile
>
> STATE: CANCELLATION_REQUESTED
>
> FOREMAN: XXXXX.com
>
> TOTAL FRAGMENTS: 1
>
>
> Major Fragment: 00-xx-xx
> <http://192.168.10.37:8047/profiles/2755683d-810b-6588-
> 25a3-49e09b9f4d3e#fragment-0>
>
> On Fri, Feb 17, 2017 at 5:17 PM, Sanjiv Kumar C <sanjivc@ejeeva.com>
> wrote:
>
> > Drill Environment:- Version: 1.9
> >                             Operating System: Linux
> >                             Mode: Embedded mode.
> >
> > I have table in sql server  having 16 lakh of data. While query through
> > drill having limit 5 but still drill take more time to show output (more
> > than 15 min)
> >
> > Ex:- select * from <pluginName).<schemaName>.<tableName> limit 5;
> >
> > What should i do?
> >
> > --
> > Thanks & Regards
> >   * Sanjiv Kumar*
> >
>
>
>
> --
> Thanks & Regards
>   * Sanjiv Kumar*
>

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