Re: Cassandra data retention policy

2014-04-29 Thread Redmumba
ble: and > default_time_to_live=86400 . > > > > *From:* Redmumba [mailto:redmu...@gmail.com] > *Sent:* Monday, April 28, 2014 12:51 PM > *To:* user@cassandra.apache.org > *Subject:* Re: Cassandra data retention policy > > > > Have you looked into using a TTL? You can set this

Re: Cassandra data retention policy

2014-04-28 Thread Jon Haddad
ble: and > default_time_to_live=86400 . > > From: Redmumba [mailto:redmu...@gmail.com] > Sent: Monday, April 28, 2014 12:51 PM > To: user@cassandra.apache.org > Subject: Re: Cassandra data retention policy > > Have you looked into using a TTL? You can set this per i

Re: Cassandra data retention policy

2014-04-28 Thread tommaso barbugli
Donald Smith : > CQL lets you specify a default TTL per column family/table: and > default_time_to_live=86400 . > > > > *From:* Redmumba [mailto:redmu...@gmail.com] > *Sent:* Monday, April 28, 2014 12:51 PM > *To:* user@cassandra.apache.org > *Subject:* Re: Cassandra data re

Re: Cassandra data retention policy

2014-04-28 Thread Redmumba
Have you looked into using a TTL? You can set this per insert (unfortunately, it can't be set per CF) and values will be tombstoned after that amount of time. I.e., INSERT INTO VALUES ... TTL 15552000 Keep in mind, after the values have expired, they will essentially become tombstones-

RE: Cassandra data retention policy

2014-04-28 Thread Donald Smith
CQL lets you specify a default TTL per column family/table: and default_time_to_live=86400 . From: Redmumba [mailto:redmu...@gmail.com] Sent: Monday, April 28, 2014 12:51 PM To: user@cassandra.apache.org Subject: Re: Cassandra data retention policy Have you looked into using a TTL? You can

Cassandra data retention policy

2014-04-28 Thread Han Jia
Hi guys, We have a processing system that just uses the data for the past six months in Cassandra. Any suggestions on the best way to manage the old data in order to save disk space? We want to keep it as backup but it will not be used unless we need to do recovery. Thanks in advance! -John