> I'm new to dynamo. I'm looking to implement something similar to prefix > search for keys (much like S3 allows you to list all the keys that match a > certain prefix). > Can I implement this with Cassandra? I'm using Hector as the client but > would gladly go thrift is necessary.
Range queries on keys is possible when using the order preserving partitioner; see the partitioner section of: http://wiki.apache.org/cassandra/StorageConfiguration In addition, range slicing is supported within a single row, based on column names, independently of which partitioner is used. Depending on whether your data is such that you can suitably put whatever is to be range queried over into a single row, that may allow you to do this without using the order preserving partitioner (which has some downsides in that ring balancing becomes more difficult). -- / Peter Schuller