incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shahab Yunus <shahab.yu...@gmail.com>
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?

Regards,
Shahab


On Wed, Oct 9, 2013 at 10:35 AM, Ravikumar Govindarajan <
ravikumar.govindarajan@gmail.com> 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
>

Mime
View raw message