Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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.
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB