hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohit Gupta <success.mohit.gu...@gmail.com>
Subject Re: Same tablename in DESTINATION and FROM clause
Date Fri, 16 Mar 2012 04:22:50 GMT
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 <ramkumar.sugavanam@yahoo.com>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 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 reluctant to go by the experimental results and wanted to
> confirm.
>
> Thanks,
> Ram
>
>
>
>
>
>


-- 
Best Regards,

Mohit Gupta

Mime
View raw message