drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Kinney <scott.kin...@stem.com>
Subject Re: queries take over 2 min
Date Thu, 02 Jun 2016 04:02:59 GMT
I do have an s3 plugin enabled. I'll try disabling it. I hope that's not it because ultimatly
s3 is where we want it pointed to.
I'll also try restarting the instance. I've never run across a bad instance but i'm sure it
happens. also the instance feels normal with everything else.



________________________________
Scott Kinney | DevOps
stem   |   m  510.282.1299
100 Rollins Road, Millbrae, California 94030

This e-mail and/or any attachments contain Stem, Inc. confidential and proprietary information
and material for the sole use of the intended recipient(s). Any review, use or distribution
that has not been expressly authorized by Stem, Inc. is strictly prohibited. If you are not
the intended recipient, please contact the sender and delete all copies. Thank you.

________________________________________
From: John Omernik <john@omernik.com>
Sent: Wednesday, June 01, 2016 6:59 PM
To: user
Subject: Re: queries take over 2 min

You probably already tried this, but I have gotten "bad" instances that for
whatever reason just performed horribly.  Once I terminated and restarted
all was better. May be worth a try as well.
On Jun 1, 2016 8:42 PM, "Abdel Hakim Deneche" <adeneche@maprtech.com> wrote:

> sometimes, if you have an issue in one of your storage plugin it affects
> all queries even those not querying that specific plugin. Do you have any
> enable storage plugin that's causing issues ?
>
> On Wed, Jun 1, 2016 at 2:21 PM, Scott Kinney <scott.kinney@stem.com>
> wrote:
>
> > i'm running queries on local json files and queries take over 2 min. I'm
> > running simple drill-embeded install on e2 t2.large. cpu and memory
> > utilization is very low while the query is running. even 'alter session
> > set' command takes minutes.
> >
> >
> >
> > ________________________________
> > Scott Kinney | DevOps
> > stem <http://www.stem.com/>   |   m  510.282.1299
> > 100 Rollins Road, Millbrae, California 94030
> >
> > This e-mail and/or any attachments contain Stem, Inc. confidential and
> > proprietary information and material for the sole use of the intended
> > recipient(s). Any review, use or distribution that has not been expressly
> > authorized by Stem, Inc. is strictly prohibited. If you are not the
> > intended recipient, please contact the sender and delete all copies.
> Thank
> > you.
> >
>
>
>
> --
>
> Abdelhakim Deneche
>
> Software Engineer
>
>   <http://www.mapr.com/>
>
>
> Now Available - Free Hadoop On-Demand Training
> <
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> >
>

Mime
View raw message