Chamila,
You can find more detailed explanations in previous posts on this mailing
list as to why, but a "Select count(*) from table;" query is inefficient in
Cassandra for non-trivial datasets. You will need a better way to get the
number of partition keys of a CF, which hopefully someone else in the user
list can provide, as I have never needed to do that.
On Thu, Dec 11, 2014 at 1:59 PM, Chamila Wijayarathna <
cdwijayarat...@gmail.com> wrote:
> Hi Philip,
>
> Yes, I'm using cqlsh. Is there any way I can solve this?
>
> Thank You!
>
> On Fri, Dec 12, 2014 at 12:26 AM, Philip Thompson <
> philip.thomp...@datastax.com> wrote:
>
>> I assume the query you are sending is through cqlsh. You are actually
>> getting a client-side timeout error, which is unclear in 2.1.2, but I
>> believe the error message will be more helpful as of 2.1.3.
>>
>> On Thu, Dec 11, 2014 at 1:52 PM, Chamila Wijayarathna <
>> cdwijayarat...@gmail.com> wrote:
>>
>>> Hello all,
>>>
>>> I am trying to get the number of key value pairs.
>>>
>>> I used following query for this.
>>>
>>> select count(*) from corpus.word_usage ;
>>>
>>> This returns number of key value pairs when CF is relatively small. But
>>> when I insert more key-velue pairs, I am getting error saying, "errors={},
>>> last_host=127.0.0.1".
>>>
>>> What is the reason for this? Is there any better way to get the size
>>> (number of key value pairs) of a CF in CQL?
>>>
>>> Thank You!
>>>
>>> --
>>> *Chamila Dilshan Wijayarathna,*
>>> SMIEEE, SMIESL,
>>> Undergraduate,
>>> Department of Computer Science and Engineering,
>>> University of Moratuwa.
>>>
>>
>>
>
>
> --
> *Chamila Dilshan Wijayarathna,*
> SMIEEE, SMIESL,
> Undergraduate,
> Department of Computer Science and Engineering,
> University of Moratuwa.
>
