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, Maciej Miklas
<mac.mik...@googlemail.com> wrote:
> 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"},
> 2004: {A:"v1",B:"v33", Z:"v2"}
> }
> Result would be:
> 2001: {A:"v1""},
> 2003: {C:"v4"}
>
> Is such multi-slice query possible with Cassandra? Are there any
> performance Issues (bedsides unbalanced cluster)?
>
> Thanks,
> Maciej
