incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jabbar Azam <>
Subject Re: Is there anyone who implemented time range partitions with column families?
Date Wed, 29 May 2013 16:13:56 GMT
Hello Cem,

You can get a similar effect by specifying a TTL value for data you save to
a table. If the data becomes older than the TTL value then it will
automatically be deleted by  C*


Jabbar Azam

On 29 May 2013 17:01, cem <> wrote:

> Thank you very much for the fast answer.
> Does playORM use different column families for each partition in
> Cassandra?
> Cem
> On Wed, May 29, 2013 at 5:30 PM, Jeremy Powell <>wrote:
>> Cem, yes, you can do this with C*, though you have to handle the logic
>> yourself (other libraries might do this for you, seen the dev of playORM
>> discuss some things which might be similar).  We use Astyanax
>> and programmatically create CFs based on a time period of our choosing that
>> makes sense for our system, programmatically drop CFs if/when they are
>> outside a certain time period (rather than using C*'s TTL), and write data
>> to the different CFs as needed.
>> ~Jeremy
>> On Wed, May 29, 2013 at 8:36 AM, cem <> wrote:
>>> Hi All,
>>> I used time range partitions 5 years ago with MySQL to clean up data
>>> much faster.
>>> I had a big FACT table with time range partitions and it was very is to
>>> drop old partitions (with archiving) and do some saving on disk.
>>> Has anyone implemented such a thing in Cassandra? It would be great if
>>> we have that in Cassandra.
>>> Best Regards,
>>> Cem.

View raw message