Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Insert into vs Insert overwrite


Copy link to this message
-
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#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.
>