Insert into vs Insert overwrite

[Kasun Weranga]

Hi all,

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

Thanks,
Kasun.

[Tamil A]

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

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