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,

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",