> Thanks for you input, but we have a set key that consists of name:timestamp > that we are using.. and we need to also retrieve the oldest data as well.. >
Then you'll need to denormalize and store every row three ways: timestamp, inverted timestamp, and normal, if you want to be able to access them in all three ways using OPP. I would recommend not using OPP and just using timeline rows. Here's a fantastic discussion of OrderPreservingPartitioner vs RandomPartitioner<http://ria101.wordpress.com/2010/02/22/cassandra-randompartitioner-vs-orderpreservingpartitioner/> . -- Tyler Hobbs Software Engineer, DataStax <http://datastax.com/> Maintainer of the pycassa <http://github.com/pycassa/pycassa> Cassandra Python client library