You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cassandra.apache.org by Eric Evans <ee...@acunu.com> on 2012/05/04 17:54:18 UTC

Re: Misleading CQL behaviour regarding LIMIT clause

On Thu, May 3, 2012 at 8:07 PM, Roshan <co...@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