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
mapreduce approach might work better for this. Is there something similar
to aggregate data in such a way in Cassandra ?
Thank you,
Saurabh
