incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremy Powell <jeremym.pow...@gmail.com>
Subject Re: Is there anyone who implemented time range partitions with column families?
Date Wed, 29 May 2013 15:30:57 GMT
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 <cayiroglu@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.
>

Mime
View raw message