Re: Question about how to remove data

2015-08-22 Thread Analia Lorenzatto
Thanks guys for the answers! Saludos / Regards. Analía Lorenzatto. "Hapiness is not something really made. It comes from your own actions" by Dalai Lama On 21 Aug 2015 2:31 pm, "Sebastian Estevez" wrote: > To clarify, you do not need a ttl for deletes to be compacted away in > Cassandra. Whe

Re: Question about how to remove data

2015-08-21 Thread Sebastian Estevez
To clarify, you do not need a ttl for deletes to be compacted away in Cassandra. When you delete, we create a tombstone which will remain in the system __at least__ gc grace seconds. We wait this long to give the tombstone a chance to make it to all replica nodes, the best practice is to run repair

Re: Question about how to remove data

2015-08-20 Thread Daniel Chia
The TTL shouldn't matter if you deleted the data, since to my understanding the delete should shadow the data signaling to C* that the data is a candidate for removal on compaction. Others might know better, but it could very well be the fact that gc_grace_seconds is 0 that is causing your problem

Re: Question about how to remove data

2015-08-20 Thread Analia Lorenzatto
Hello, Daniel, I am using Size Tiered compaction. My concern is that as I do not have a TTL defined on the Column family, and I do not have the possibility to create it. Perhaps, the "deleted data" is never actually going to be removed? Thanks a lot! On Thu, Aug 20, 2015 at 4:24 AM, Daniel C

Re: Question about how to remove data

2015-08-20 Thread Daniel Chia
Is this a LCS family, or Size Tiered? Manually running compaction on LCS doesn't do anything until C* 2.2 ( https://issues.apache.org/jira/browse/CASSANDRA-7272) Thanks, Daniel On Wed, Aug 19, 2015 at 6:56 PM, Analia Lorenzatto < analialorenza...@gmail.com> wrote: > Hello Michael, > > Thanks for

Re: Question about how to remove data

2015-08-19 Thread Analia Lorenzatto
Hello Michael, Thanks for responding! I do not have snapshots on any node of the cluster. Saludos / Regards. Analía Lorenzatto. "Hapiness is not something really made. It comes from your own actions" by Dalai Lama On 19 Aug 2015 6:19 pm, "Laing, Michael" wrote: > Possibly you have snapshot

Re: Question about how to remove data

2015-08-19 Thread Laing, Michael
Possibly you have snapshots? If so, use nodetool to clear them. On Wed, Aug 19, 2015 at 4:54 PM, Analia Lorenzatto < analialorenza...@gmail.com> wrote: > Hello guys, > > I have a cassandra cluster 2.1 comprised of 4 nodes. > > I removed a lot of data in a Column Family, then I ran manually a > co

Question about how to remove data

2015-08-19 Thread Analia Lorenzatto
Hello guys, I have a cassandra cluster 2.1 comprised of 4 nodes. I removed a lot of data in a Column Family, then I ran manually a compaction on this Column family on every node. After doing that, If I query that data, cassandra correctly says this data is not there. But the space on disk is e