Alter table

[y_...@tsmc.com]

Hi,
I want to keep only one version of my data (now is 3)
How can I do that?

Fleming Chiu(邱宏明)
707-6128
y_823910@tsmc.com
週一無肉日吃素救地球(Meat Free Monday Taiwan)


 --------------------------------------------------------------------------- 
                                                         TSMC PROPERTY       
 This email communication (and any attachments) is proprietary information   
 for the sole use of its                                                     
 intended recipient. Any unauthorized review, use or distribution by anyone  
 other than the intended                                                     
 recipient is strictly prohibited.  If you are not the intended recipient,   
 please notify the sender by                                                 
 replying to this email, and then delete this email and any copies of it     
 immediately. Thank you.                                                     
 --------------------------------------------------------------------------- 

Re: Alter table

[stack <st...@duboce.net>]

On creation of your table, specify that you only want to keep one version.
 If the table already exists, offline it and alter it.  Set maximum versions
to 1 then online your table again.  As the table runs compactions, it will
let go of versions in excess of 1.

If you type help in the shell, it has examples of how to both alter and
create tables setting versions other than default.

St.Ack

2010/1/10 <y_...@tsmc.com>

> Hi,
> I want to keep only one version of my data (now is 3)
> How can I do that?
>
> Fleming Chiu(邱宏明)
> 707-6128
> y_823910@tsmc.com
> 週一無肉日吃素救地球(Meat Free Monday Taiwan)
>
>
>
>  ---------------------------------------------------------------------------
>                                                         TSMC PROPERTY
>  This email communication (and any attachments) is proprietary information
>  for the sole use of its
>  intended recipient. Any unauthorized review, use or distribution by anyone
>  other than the intended
>  recipient is strictly prohibited.  If you are not the intended recipient,
>  please notify the sender by
>  replying to this email, and then delete this email and any copies of it
>  immediately. Thank you.
>
>  ---------------------------------------------------------------------------
>
>
>
>