incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hiller, Dean" <Dean.Hil...@nrel.gov>
Subject Re: Is there anyone who implemented time range partitions with column families?
Date Wed, 29 May 2013 16:06:29 GMT
Nope, partitioning is done per CF in PlayOrm.

Dean

From: cem <cayiroglu@gmail.com<mailto:cayiroglu@gmail.com>>
Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <user@cassandra.apache.org<mailto:user@cassandra.apache.org>>
Date: Wednesday, May 29, 2013 10:01 AM
To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <user@cassandra.apache.org<mailto:user@cassandra.apache.org>>
Subject: Re: Is there anyone who implemented time range partitions with column families?

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 <jeremym.powell@gmail.com<mailto:jeremym.powell@gmail.com>>
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 <cayiroglu@gmail.com<mailto: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