Hi all,

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

Thanks,
Kasun.

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.
>