Please refer to the Hive Language Manual: http://wiki.apache.org/hadoop/Hive/LanguageManual/DML#Inserting_data_into_Hive_Tables_from_queries
Loading data into a sub-partition of a table is the same as loading data into regular table with the partition predicate specified. For example: LOAD DATA LOCAL INPATH '/path/to/data/file' OVERWRITE INTO TABLE table_name partition *( part_column = part_column_value)* More information on manipulating partitions as a whole is available here: http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Add_Partitions Hope this helps. -Arvind On Fri, May 7, 2010 at 6:54 PM, <[email protected]> wrote: > Thanks for your reply, can you give me some example about adding a sub > partition to a Partition? > > How can I achieve that creating a new directory/file per append > > > > -----邮件原件----- > > 发件人: Zheng Shao [mailto:[email protected]] > > 发送时间: 2010年5月8日 2:29 > > 收件人: [email protected] > > 主题: Re: can hive currently support appending data to the table? > > > > 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 > > > ------------------------------ > > 你的1G网络U盘真好用！ <http://goto.mail.sohu.com/goto.php?code=udisk_zhujiao> > 查薪酬：对比同行工资！<http://sohu.ad-plus.cn/event.ng/Type=click&FlightID=201004&TargetID=sohu&Values=df789d86,92d3d91d,277177cc,c2935d8d&AdID=54157>
