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*
>
|