Purge Data

["Bahadur, Kamal" <Ka...@digitalinsight.com>]

>From the documentation, I came to know that there is a limitation of
maximum number (2 billion) of columns that a column family can have. My
questions is, is there a way to purge the old columns when the number of
columns is nearing the 2 billion mark?

 

Thanks,

Kamal

Re: Purge Data

[Jonathan Ellis <jb...@gmail.com>]

Remember that you should have many more rows of size X than you have
cluster nodes for any value of X.

So if you have a data model where a handful of rows may have > 2B
columns but the rest will be much smaller, you should probably rethink
that.

On Thu, Jun 9, 2011 at 10:51 AM, Bahadur, Kamal
<Ka...@digitalinsight.com> wrote:
> From the documentation, I came to know that there is a limitation of maximum
> number (2 billion) of columns that a column family can have. My questions
> is, is there a way to purge the old columns when the number of columns is
> nearing the 2 billion mark?
>
>
>
> Thanks,
>
> Kamal



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com

Re: Purge Data

[Jeremy Hanna <je...@gmail.com>]

Have you looked at the TTL column feature in 0.7? 
http://www.datastax.com/dev/blog/whats-new-cassandra-07-expiring-columns

Those will automatically expire columns after a certain time period - not when you near the column limit, but might be helpful for you.

On Jun 9, 2011, at 10:51 AM, Bahadur, Kamal wrote:

> From the documentation, I came to know that there is a limitation of maximum number (2 billion) of columns that a column family can have. My questions is, is there a way to purge the old columns when the number of columns is nearing the 2 billion mark?
>  
> Thanks,
> Kamal