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] ta...@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 <de...@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 < > lilyev...@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 > >
<<tokLogo.png>>
