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