incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ben Hood <0x6e6...@gmail.com>
Subject Re: Data model for boolean attributes
Date Sat, 22 Mar 2014 03:38:40 GMT
On Sat, Mar 22, 2014 at 3:32 AM, Ben Hood <0x6e6562@gmail.com> wrote:
> Also a very good point. The main query paths the app needs to support are:
>
> select * from x where flag=true and id = ? and timestamp >= ? and timestamp <=
?
> select * from x where flag=false and id = ? and timestamp >= ? and
> timestamp <= ?
>
> In this app, ordering by id is not important.

It also needs to be able to paginate through the entire column family
flag=false i.e.

select * from x where flag=false
select distinct id from x where flag=false

Mime
View raw message