alter table add column

[Mona Meena <dr...@hotmail.com>]

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
 		 	   		  

Re: alter table add column

[Noam Hasson <no...@kenshoo.com>]

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.