Deleting column data from Cassandra without setting its TTL

2013-08-16 Thread Suruchi Deodhar
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

Re: Deleting column data from Cassandra without setting its TTL

2013-08-16 Thread Arthur Zubarev
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? Regards Arthur From: Suruchi Deodhar Sent: Friday, August 16, 2013 12:23 PM To: user@cassandra.apache.org Subject: Deleting column data from Cassandra without setting

Re: Deleting column data from Cassandra without setting its TTL

2013-08-16 Thread Suruchi Deodhar
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

Re: Deleting column data from Cassandra without setting its TTL

2013-08-16 Thread Arthur Zubarev
Subject: Re: Deleting column data from Cassandra without setting its TTL 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