RE: Need urgent help on hive query performance

2014-06-01 Thread shouvanik.haldar
urgency. Thanks, Shouvanik From: Bala Krishna Gangisetty [mailto:b...@altiscale.com] Sent: Friday, May 30, 2014 4:08 PM To: user@hive.apache.org Subject: Re: Need urgent help on hive query performance Another dimension, Try storing Hive table in ORC format. From my experience, it significantly

Re: Need urgent help on hive query performance

2014-05-30 Thread Bala Krishna Gangisetty
com [mailto:kulkarni.swar...@gmail.com] >> *Sent:* Friday, May 30, 2014 3:34 PM >> >> *To:* user@hive.apache.org >> *Subject:* Re: Need urgent help on hive query performance >> >> >> >> I feel it's pretty hard to answer this without understanding th

Re: Need urgent help on hive query performance

2014-05-30 Thread kulkarni.swar...@gmail.com
nswers > > > > > > > > *From:* kulkarni.swar...@gmail.com [mailto:kulkarni.swar...@gmail.com] > *Sent:* Friday, May 30, 2014 3:34 PM > > *To:* user@hive.apache.org > *Subject:* Re: Need urgent help on hive query performance > > > > I feel it's pre

RE: Need urgent help on hive query performance

2014-05-30 Thread shouvanik.haldar
Pls find the answers From: kulkarni.swar...@gmail.com [mailto:kulkarni.swar...@gmail.com] Sent: Friday, May 30, 2014 3:34 PM To: user@hive.apache.org Subject: Re: Need urgent help on hive query performance I feel it's pretty hard to answer this without understanding the following

Re: Need urgent help on hive query performance

2014-05-30 Thread Ashish Garg
7;; This will optimize your query performance. On Fri, May 30, 2014 at 6:32 PM, wrote: > Can you please give a specific example or blog to refer to. I did not > understand > > > > *From:* Ashish Garg [mailto:gargcreation1...@gmail.com] > *Sent:* Friday, May 30, 2014 3:31 PM

Re: Need urgent help on hive query performance

2014-05-30 Thread kulkarni.swar...@gmail.com
g [mailto:gargcreation1...@gmail.com] > *Sent:* Friday, May 30, 2014 3:31 PM > *To:* user@hive.apache.org > *Subject:* Re: Need urgent help on hive query performance > > > > try partitioning the table and run the queries which are partition > specific. Hope this helps. > > Thanks

RE: Need urgent help on hive query performance

2014-05-30 Thread shouvanik.haldar
Can you please give a specific example or blog to refer to. I did not understand From: Ashish Garg [mailto:gargcreation1...@gmail.com] Sent: Friday, May 30, 2014 3:31 PM To: user@hive.apache.org Subject: Re: Need urgent help on hive query performance try partitioning the table and run the

Re: Need urgent help on hive query performance

2014-05-30 Thread Ashish Garg
try partitioning the table and run the queries which are partition specific. Hope this helps. Thanks and Regards, Ashish Garg. On Fri, May 30, 2014 at 6:05 PM, wrote: > Hi, > > > > Does anybody help urgently on optimizing hive query performance? I am > looking more Hadoop tuning point of view

Need urgent help on hive query performance

2014-05-30 Thread shouvanik.haldar
Hi, Does anybody help urgently on optimizing hive query performance? I am looking more Hadoop tuning point of view. Currently, small amount of table takes much time to query? We are running EMR cluster with 1 MASTER node, 2 Core Nodes and Task Nodes. Quick help is much appreciated. Thanks,