Cassandra - row range and column slice

2012-02-17 Thread Maciej Miklas
Hallo, assuming Ordered Partitioner I would like to have possibility to find records by row key range and columns by slice - for example: Give me all rows between 2001 and 2003 and all columns between A and C. For such data: { 2001: {A:v1, Z:v2}, 2002: {R:v2, Z:v3}, 2003: {C:v4, Z:v5},

Re: Cassandra - row range and column slice

2012-02-17 Thread Pierre-Yves Ritschard
In this case, you have one query predicate that operates on a much lower range (years) you could use it as the row key and issue a multigetslicequery where you set all row keys and specify the slice you're interested in (here: 2001 2002 2003, then = A, D) On Fri, Feb 17, 2012 at 11:46 AM,