Re: Need urgent help in hive query

2013-07-02 Thread dyuti a
rk; second, optimize. > > Robin > > From: dyuti a > Reply-To: "user@hive.apache.org" > Date: Friday, June 28, 2013 12:05 PM > To: "user@hive.apache.org" > Subject: Re: Need urgent help in hive query > > Hi Robin, > Thanks for your reply. H

Re: Need urgent help in hive query

2013-06-28 Thread Robin Morris
.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Friday, June 28, 2013 12:05 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: Re: Need urgent help in hive query Hi Robin, Thanks for yo

Re: Need urgent help in hive query

2013-06-28 Thread dyuti a
Hi Robin, Thanks for your reply. Hope this will help us but still looking into performance wise tooif no other option then have to go by this. Dti On Sat, Jun 29, 2013 at 12:03 AM, Robin Morris wrote: > Split up the query – put results of the subquery into a table, run the > final query o

Re: Need urgent help in hive query

2013-06-28 Thread Robin Morris
Split up the query – put results of the subquery into a table, run the final query on that, then drop the temporary table. Robin From: dyuti a mailto:hadoop.hiv...@gmail.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Friday, June 28, 2013