Re: Insert into vs Insert overwrite

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#LanguageM

Insert into vs Insert overwrite

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