cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pierre-Yves Ritschard <...@spootnik.org>
Subject Re: Cassandra - row range and column slice
Date Fri, 17 Feb 2012 11:16:40 GMT
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.miklas@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

Mime
View raw message