You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Leonid Ilyevsky <li...@mooncapital.com> on 2012/06/12 20:40:50 UTC
select count(*) returns 10000
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.
Re: Help with configuring replication
Posted by aaron morton <aa...@thelastpickle.com>.
Some docs here http://www.datastax.com/docs/1.0/initialize/index
Cheers
-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 14/06/2012, at 8:14 AM, Leonid Ilyevsky wrote:
> Before going into complex clustering topologies, I would like to try the most simple configuration: just set up two nodes that will completely replicate each other.
> Could somebody tell me how to configure it?
>
> Thanks!
>
> 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.
Help with configuring replication
Posted by Leonid Ilyevsky <li...@mooncapital.com>.
Before going into complex clustering topologies, I would like to try the most simple configuration: just set up two nodes that will completely replicate each other.
Could somebody tell me how to configure it?
Thanks!
________________________________
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.
Re: select count(*) returns 10000
Posted by Tamar Fraenkel <ta...@tok-media.com>.
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 <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 <
> 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
>
>
Re: select count(*) returns 10000
Posted by Derek Williams <de...@fyrie.net>.
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