Hive, mail # user - Insert into vs Insert overwrite

Insert into vs Insert overwrite

Kasun Weranga 2012-10-03, 12:37

Hi all,

I would like to know the difference between Hive insert into and insert
overwrite for a Hive external table.

Thanks,
Kasun.

Re: Insert into vs Insert overwrite

Tamil A 2012-10-03, 13:28

Hi Kasun,

INSERT OVERWRITE will overwrite any existing data in the table or partition
and INSERT INTO will append to the table or partition keeping the existing
data.

Please have a look into the below link for the same.
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingdataintoHiveTablesfromqueries
-Hope it helps,
Tamil

On Wed, Oct 3, 2012 at 6:07 PM, Kasun Weranga <[EMAIL PROTECTED]> wrote:

> Hi all,
>
> I would like to know the difference between Hive insert into and insert
> overwrite for a Hive external table.
>
> Thanks,
> Kasun.
>