incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: Deleting old items
Date Tue, 12 Feb 2013 17:00:54 GMT
> So is it possible to delete all the data inserted in some CF between 2 dates or data older
than 1 month ?
No. 

You need to issue row level deletes. If you don't know the row key you'll need to do range
scans to locate them. 

If you are deleting parts of wide rows consider reducing the min_compaction_level_threshold
on the CF to 2

Cheers


-----------------
Aaron Morton
Freelance Cassandra Developer
New Zealand

@aaronmorton
http://www.thelastpickle.com

On 12/02/2013, at 4:21 AM, Alain RODRIGUEZ <arodrime@gmail.com> wrote:

> Hi,
> 
> I would like to know if there is a way to delete old/unused data easily ?
> 
> I know about TTL but there are 2 limitations of TTL:
> 
> - AFAIK, there is no TTL on counter columns
> - TTL need to be defined at write time, so it's too late for data already inserted.
> 
> I also could use a standard "delete" but it seems inappropriate for such a massive.
> 
> In some cases, I don't know the row key and would like to delete all the rows starting
by, let's say, "1050#..." 
> 
> Even better, I understood that columns are always inserted in C* with (name, value, timestamp).
So is it possible to delete all the data inserted in some CF between 2 dates or data older
than 1 month ?
> 
> Alain


Mime
View raw message