cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shahab <shahab.mok...@gmail.com>
Subject Re: Why "select count("*) from .." hangs ?
Date Wed, 26 Mar 2014 08:34:24 GMT
Thanks for the hints. I got a better picture of how to deal with "count"
queries.


On Tue, Mar 25, 2014 at 7:01 PM, Robert Coli <rcoli@eventbrite.com> wrote:

> On Tue, Mar 25, 2014 at 8:36 AM, shahab <shahab.mokari@gmail.com> wrote:
>
>> But after iteration 8,  (i.e. inserting  1500000 sensor data), the
>> "select count(') ...)  throws time-out exception and doesn't work anymore.
>> I even tried  to execute "select count(*)..." using Datastax DevCenter GUI,
>> but I got same result.
>>
>
> All operations in Cassandra are subject to (various) timeouts, which by
> default are in the scale of single digit seconds.
>
> If you attempt to do an operation (such as aggregates across large numbers
> of large objects) which cannot complete in this time, this is a strong
> indication that either your overall approach is inappropriate or, at very
> least, that your buckets are too large.
>
> =Rob
>
>

Mime
View raw message