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

Same tablename in DESTINATION and FROM clause

2012-03-15 Thread Ramkumar
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 precise, is it safe to write query in the following way, insert overwrite table X select do_something from X join Y  on (some key) Was little