incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suruchi Deodhar <suruchi.deod...@generalsentiment.com>
Subject Re: Deleting column data from Cassandra without setting its TTL
Date Fri, 16 Aug 2013 18:38:28 GMT
We are using the cassandra thrift interface to interact with Cassandra.

In our use case, we store time-series data with one column per day (per
row-key) , and we have a fixed number of column families to store data over
time. Since we have data for hundreds of days, we cannot create
column-families for individual time-ranges easily ( if that's what you're
suggesting). Is there another way we can achieve what we intend to do ?

Thanks


On Fri, Aug 16, 2013 at 2:29 PM, Arthur Zubarev <Arthur.Zubarev@aol.com>wrote:

>   Not sure what client you use to interact with C*. In your scenario I
> assume it is CQL.
>
> So what can go wrong with TRUNCATE<http://www.datastax.com/docs/1.0/references/cql/TRUNCATE>
> ?
>
> Regards
>
> Arthur
>
>  *From:* Suruchi Deodhar <suruchi.deodhar@generalsentiment.com>
> *Sent:* Friday, August 16, 2013 12:23 PM
> *To:* user@cassandra.apache.org
> *Subject:* Deleting column data from Cassandra without setting its TTL
>
>  What is the best way to delete column data from a Cassandra cluster
> after it is backed up with snapshots (using Priam or otherwise) to a stable
> storage?
>
> We dont want to use the TTL option, since we would like to restore the
> backed-up data in the Cassandra cluster at a later time.  Setting a TTL
> would enable the tombstone marker, which would make it impossible to
> restore data.
>
> What are the available options in Cassandra 1.2.5 in particular?
>
> Thanks!
>

Mime
View raw message