We looking for solution for same problem. We have a wide column family with
counters and we want to delete old data like 1 months old. One of potential
ideas was to implement hook in compaction code and drop column which we
don't need. Is this a viable option?
From: aaron morton
Sent: Tuesday, February 12, 2013 9:01 AM
Subject: Re: Deleting old items
So is it possible to delete all the data inserted in some CF between 2 dates
or data older than 1 month ?
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
Freelance Cassandra Developer