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 Threaded View
Hive >> mail # user >> insert into not supported?


Copy link to this message
-
RE: insert into not supported?
a work around right now is

insert overwrite t
select * from (select * from t union all select * from t_new)
Ashish

________________________________
From: Namit Jain [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 21, 2009 2:38 PM
To: [EMAIL PROTECTED]
Subject: RE: insert into not supported?

Currently, hive only supports overwriting the data - appending is not supported
From: chen keven [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 21, 2009 2:34 PM
To: [EMAIL PROTECTED]
Subject: insert into not supported?

I tried to use" insert into "  command to insert data in table. However, hive doesn't recognize it. It gives me error like mismatched input 'into' expecting overwrite in insert clause.
"insert overwrite" simply overwrite the data in the table. But I need to concatenate the data. I did a quick search, I found some previous presentation talking about insert into. Did I do something wrong?

--
Thank you,
Keven Chen
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