data aggregation in Cassandra

[Saurabh Sehgal]

Hi All,

I am evaluating Cassandra as a data store for my application.

This is what the format of the data I want to store looks like:

{
   timestampuuid: unique time stamp
   finite_set_of_values_attribute1:  this is a value from a finite set ,
lets say {a,b,c,d}
   finite_set_of_values_attribute2:  this is a value from a finite set, lets
say  {e,f,g}
   randomAttribute: xyz
   randomAttribute: 123
}

How can I efficiently model this data to answer questions like:

1. From timestampuuid1 to timestampuuid2 I want all values
with  finite_set_of_values_attribute1 = "a",
and  finite_set_of_values_attribute2 = "e"
2. I want all values from timestamp1 to timestamp2 sorted by
finite_set_of_values_attribute1

Is it possible to do such data aggregations efficiently ? I sense a
map-reduce approach might work better for this.  Is there something similar
to aggregate data in such a way in Cassandra ?

Thank you,

Saurabh