Home | About | Sematext search-lucene.com search-hadoop.com
 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)

From: Namit Jain [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 21, 2009 2:38 PM
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
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