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