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 <cayiro...@gmail.com> 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. >