If you want to add data to an already existing rows you'll have to insert the data again by using insert overwrite, perhaps it's better to insert into a new table.
On Wed, Jul 8, 2015 at 11:57 PM, Mona Meena <dr....@hotmail.com> wrote: > Hi, > > I have a partitioned table. Is it possible to alter this table by adding a > new column and also update the table by inserting data into the new column? > I know how to add a new column but no idea how to insert data into the new > column. Any suggestions please > > BR, > Mona > -- This e-mail, as well as any attached document, may contain material which is confidential and privileged and may include trademark, copyright and other intellectual property rights that are proprietary to Kenshoo Ltd, its subsidiaries or affiliates ("Kenshoo"). This e-mail and its attachments may be read, copied and used only by the addressee for the purpose(s) for which it was disclosed herein. If you have received it in error, please destroy the message and any attachment, and contact us immediately. If you are not the intended recipient, be aware that any review, reliance, disclosure, copying, distribution or use of the contents of this message without Kenshoo's express permission is strictly prohibited.