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

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

Kasun Weranga 2012-10-03, 12:37
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

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.