Re: select count(*) returns 10000

2012-06-12 Thread Tamar Fraenkel
Add "limit N" and it will count more than 1. 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 P

Re: select count(*) returns 10000

2012-06-12 Thread Derek Williams
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 wrote: > The "select count(*) ..." query returns correct count only if it is <= > 1, otherwise it returns exactly 10

select count(*) returns 10000

2012-06-12 Thread Leonid Ilyevsky
The "select count(*) ..." query returns correct count only if it is <= 1, otherwise it returns exactly 1. 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 disclo