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

Please have a look into the below link for the same.
-Hope it helps,

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.