cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Evans <eev...@acunu.com>
Subject Re: Misleading CQL behaviour regarding LIMIT clause
Date Fri, 04 May 2012 15:54:18 GMT
On Thu, May 3, 2012 at 8:07 PM, Roshan <codevally@gmail.com> wrote:
> I have created a CF and it has around 10 million rows. But If I try to
> select statement with the LIMIT 100, it returns 79 records. Don't know why
> this behavior?
>
> *Statement I used:*
> SELECT * FROM ActivityLog WHERE userid = '%s' AND created >= '%s' AND
> created <= '%s' LIMIT 100

My guess would be that, total number of rows in the columnfamily
notwithstanding, there are only 79 for the given the predicates.

-- 
Eric Evans
Acunu | http://www.acunu.com | @acunu

Mime
View raw message