Re: Same tablename in DESTINATION and FROM clause

2012-03-16 Thread Mohit Gupta
erved is: “yes” if the table is HDFS-backed; “it depends” > if otherwise. > > ** ** > > ** ** > > *From:* Mohit Gupta [mailto:success.mohit.gu...@gmail.com] > *Sent:* Thursday, March 15, 2012 9:23 PM > *To:* user@hive.apache.org; Ramkumar > > *Subject:* Re: Same

RE: Same tablename in DESTINATION and FROM clause

2012-03-16 Thread Steven Wong
What I've observed is: "yes" if the table is HDFS-backed; "it depends" if otherwise. From: Mohit Gupta [mailto:success.mohit.gu...@gmail.com] Sent: Thursday, March 15, 2012 9:23 PM To: user@hive.apache.org; Ramkumar Subject: Re: Same tablename in DESTINATION and FROM cl

Re: Same tablename in DESTINATION and FROM clause

2012-03-16 Thread Ramkumar
Thanks mohit. From: Mohit Gupta To: user@hive.apache.org; Ramkumar Sent: Friday, March 16, 2012 4:22 AM Subject: Re: Same tablename in DESTINATION and FROM clause No. First write the result in a temp table, then load it into the original table. On Thu

Re: Same tablename in DESTINATION and FROM clause

2012-03-15 Thread Mohit Gupta
No. First write the result in a temp table, then load it into the original table. On Thu, Mar 15, 2012 at 4:53 PM, Ramkumar wrote: > Hi, > > Does the MR jobs of a hive query write directly to the destination or are > the results of the MR jobs moved to the destination at the end? > To be more pre