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 OVERWRITE? Is there another alternative at present other than INSERT to a temp table and doing a 'copy' of the results files to the correct directory of the table to be appended to? Thanks - Neal
