And of course you can always create the table with a dummy partition key
just for later appends tho of course this adds the caveat of having to
always specifiy a partition and to manage collision-avoidance youself.

On Aug 8, 2009 3:36 PM, "Namit Jain" <[email protected]> wrote:

 There is no support for INSERT APPEND TABLE right now.

The workaround is to select the same table and a union all


For eg:

If you want to insert append into table T


Insert append table T select xxx

Is same as:


Insert overwrite table T
Select xxx
Union all
Select * from T




-namit

On 8/8/09 11:59 AM, "Neal Richter" <[email protected]> wrote:

> Hey all, >    Is there any news on having an 'INSERT APPEND TABLE' rather
than forcing use of OVER...

Reply via email to