Abhi, Bejoy is right. To add to the remark, "insert into" doesn't work on bucketed tables as of now. For non-bucketed tables, it should work if you are using Hive version 0.8 or higher.
More details on this thread: http://mail-archives.apache.org/mod_mbox/hive-user/201206.mbox/%3c263112076.394989.1338524796872.javamail.r...@sms-zimbra-message-store-03.sms.scalar.ca%3E If your create table statement contained "CLUSTERED BY" clause, then your table is bucketed; otherwise it's not. Mark ----- Original Message ----- From: "Bejoy KS" <bejoy...@yahoo.com> To: user@hive.apache.org Sent: Wednesday, July 4, 2012 1:35:48 AM Subject: Re: Hive insert into Hi Abhi When you say INSERT INTO in hive it needn't be a file append. In hive the data corresponding to a table/partition is in a directory, data is stored as one or more files within those. AFAIK when you do insert into, a new file is created in the directory along with old files. So hdfs file append needn't come to picture here. Regards Bejoy KS Sent from handheld, please excuse typos. -----Original Message----- From: abhiTowson cal <abhishek.dod...@gmail.com> Date: Wed, 4 Jul 2012 00:40:03 To: <user@hive.apache.org> Reply-To: user@hive.apache.org Subject: Re: Hive insert into hi youngwoo Thanks for your reply.Can you justify your answer hdfs doesnot support append, so how hive does it? Regards Abhi On Tue, Jul 3, 2012 at 11:56 PM, 김영우 <warwit...@gmail.com> wrote: > Abhi, > > Hive supports INSERT INTO syntax but you should use Hive 0.8 or higher. See > https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingdataintoHiveTablesfromqueries > > - Youngwoo > > On Wed, Jul 4, 2012 at 11:19 AM, Abhishek <abhishek.dod...@gmail.com> wrote: >> >> Hi all, >> >> Will hive support INSERT INTO ? and It is nothing but, appending new data >> to the existing data.Can any one please tell me how does it happen and which >> version of hive supports this? >> >> Regards >> Abhi >> >> >> >> Sent from my iPhone > >
