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?
Ashish Thusoo 2009-07-21, 21:41
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