Drill will register schema tree for each enabled storage plugin, even though the query does not refer to one particular SP. If your s3 is very slow, it's possible that such slow SP will impact all the queries.
On Wed, Jun 1, 2016 at 9:02 PM, Scott Kinney <[email protected]> wrote: > 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 <[email protected]> > 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" <[email protected]> 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 <[email protected]> >> 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 >> > >>
