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
