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
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"
/><o:p> </o:p>
-----邮件原件-----
发件人: Zheng Shao [mailto:[email protected]]
发送时间: 2010年5月8日 2:29
收件人: [email protected]
主题: Re: can hive currently support appending data to the table?
<o:p> </o:p>
We can also add more partitions to a table (or a sub partition to a
partition) to simulate appending to table/partition.
<o:p> </o:p>
There is no real efficiency loss except that we will create a new
directory/file per append.
<o:p> </o:p>
Zheng
<o:p> </o:p>
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.
><o:p> </o:p>
> Of course you are welcome to add this to the project.
> Thanks,
> Ning
> ------
> Sent from my blackberry
><o:p> </o:p>
> ________________________________
> 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?
><o:p> </o:p>
> I read the hive wiki, it says:
><o:p> </o:p>
> The output of each of the select statements is written to the chosen
> table (or partition).
><o:p> </o:p>
> 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
><o:p> </o:p>
><o:p> </o:p>
><o:p> </o:p>
> can hive currently support appending data to the table?
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
--
Yours,
Zheng
http://www.linkedin.com/in/zshao
