cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shahab Yunus <>
Subject Re: Deleting data using timestamp
Date Wed, 09 Oct 2013 17:27:16 GMT
I might be missing something obvious here but can't you afford (time-wise)
to run cleanup or repair after the deletion so that the deleted data is
gone? Assuming that  your columns are time-based data?


On Wed, Oct 9, 2013 at 10:35 AM, Ravikumar Govindarajan <> wrote:

> We have wide-rows accumulated in a cassandra CF and now changed our
> app-side logic.
> The application now only wants first 7 days of data from this CF.
> What is the quick way to delete old-data and at the same time make sure
> read does churn through all deleted columns?
> Lets say I do the following
> for (each key in CF)
>       drop key, with timestamp=(System.currentTimeMillis-7days)
> What should I do in my read, to make sure that deleted columns don't get
> examined.
> I saw some advice on using max-timestamp per SSTable during read. Can
> someone explain if that will solve my read problem here?
> --
> Ravi

View raw message