cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tamar Fraenkel <ta...@tok-media.com>
Subject Re: select count(*) returns 10000
Date Wed, 13 Jun 2012 06:02:27 GMT
Add "limit N" and it will count more than 10000.
Of course it will be slow when you increase N.

*Tamar Fraenkel *
Senior Software Engineer, TOK Media

[image: Inline image 1]

tamar@tok-media.com
Tel:   +972 2 6409736
Mob:  +972 54 8356490
Fax:   +972 2 5612956





On Tue, Jun 12, 2012 at 10:07 PM, Derek Williams <derek@fyrie.net> wrote:

> It's a known issue, here is a bit extra info on it:
> http://stackoverflow.com/questions/8795923/wrong-count-with-cassandra-cql
>
>
> On Tue, Jun 12, 2012 at 12:40 PM, Leonid Ilyevsky <
> lilyevsky@mooncapital.com> wrote:
>
>> The "select count(*) ..." query returns correct count only if it is <=
>> 10000, otherwise it returns exactly 10000.
>> This happens in both Java API and cqlsh.
>> Can somebody verify?
>>
>> This email, along with any attachments, is confidential and may be
>> legally privileged or otherwise protected from disclosure. Any unauthorized
>> dissemination, copying or use of the contents of this email is strictly
>> prohibited and may be in violation of law. If you are not the intended
>> recipient, any disclosure, copying, forwarding or distribution of this
>> email is strictly prohibited and this email and any attachments should be
>> deleted immediately.  This email and any attachments do not constitute an
>> offer to sell or a solicitation of an offer to purchase any interest in any
>> investment vehicle sponsored by Moon Capital Management LP ("Moon
>> Capital"). Moon Capital does not provide legal, accounting or tax advice.
>> Any statement regarding legal, accounting or tax matters was not intended
>> or written to be relied upon by any person as advice. Moon Capital does not
>> waive confidentiality or privilege as a result of this email.
>>
>
>
>
> --
> Derek Williams
>
>

Mime
View raw message