We can also add more partitions to a table (or a sub partition to a partition) to simulate appending to table/partition.
There is no real efficiency loss except that we will create a new directory/file per append. Zheng On Fri, May 7, 2010 at 7:51 AM, Ning Zhang <[email protected]> wrote: > Hive does not support appending to exist partition ot table yet. For non > bucketed table a workaround is to insert the new data into a temp table and > move the files to the destination by hand. > > Of course you are welcome to add this to the project. > Thanks, > Ning > ------ > Sent from my blackberry > > ________________________________ > From: luocanrao <[email protected]> > To: [email protected] <[email protected]> > Sent: Fri May 07 07:22:38 2010 > Subject: can hive currently support appending data to the table? > > I read the hive wiki, it says: > > The output of each of the select statements is written to the chosen table > (or partition). > > Currently the OVERWRITE keyword is mandatory and implies that the contents > of the chosen table or partition are replaced with the output of > corresponding select statement > > > > can hive currently support appending data to the table? -- Yours, Zheng http://www.linkedin.com/in/zshao
