Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of edlinuxguru@gmail.com
 designates 209.85.161.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=AdMOfYlTsSALQ6k1At5szoSvokcMs93hO9ScY6wjtuPb0I1MIp0N9zOdY9L9aaMANY
         ZVMyPPx8ZTFgaGBOBRq3cx1ANuOR/v734sjBMBKmNEqK7W6f54oME8CLANVhIkOVwh0s
         2QuJxK2GYFobGvA8uODbXgN61UDb2C+89OvaE=
MIME-Version: 1.0
In-Reply-To: <AANLkTikSEV8o6KtHZc4A2wvKMRZq=DvLE2cPC9Vu_kHw@mail.gmail.com>
References: <4CEFE15D.8080505@33concept.com>
	<AANLkTikSEV8o6KtHZc4A2wvKMRZq=DvLE2cPC9Vu_kHw@mail.gmail.com>
Date: Tue, 30 Nov 2010 13:13:22 -0500
Message-ID: <AANLkTimDWk-e6xiW9ef0OqMU+N9WhSMyZfod3ZN9+fP6@mail.gmail.com>
Subject: Re: get_count - cassandra 0.7.x predicate limit bug?
From: Edward Capriolo <edlinuxguru@gmail.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Nov 30, 2010 at 1:00 AM, Tyler Hobbs <tyler@riptano.com> wrote:
> What error are you getting?
>
> Remember, get_count() is still just about as much work for cassandra as
> getting the whole row; the only advantage is it doesn't have to send the
> whole row back to the client.
>
> If you're counting 3+ million columns frequently, it's time to take a look
> at counters.
>
> - Tyler
>
> On Fri, Nov 26, 2010 at 10:33 AM, Marcin <marcin@33concept.com> wrote:
>>
>> Hi guys,
>>
>> I have a key with 3million+ columns but when I am trying to run get_count
>> on it its getting me error if setting limit more than 46000+ any ideas?
>>
>> In previous API there was no predicate at all so it was simply counting
>> number of columns now its not so simple any more.
>>
>> Please let me know if that is a bug or I do something wrong.
>>
>>
>> cheers,
>> /Marcin
>
>

+1 Tyler. The problem is you can increase the clients socket timeout
as high as you like if socketTimeout < rpcTimeout you should see
SocketTimeoutExceptions if socketTimeout >= rcpTimeout you start
seeing Cassandra TimedOutExceptions. Raising the RPC Timeout is done
on the server. In any case you may have to range_slice to get through
a row this big and count. Also in my experience rows this large do not
work well. They are particularly dangerous when combined with RowCache
as bringing them into to memory and evicting them is both disk and
memory intensive.