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 <rc...@eventbrite.com> wrote: > On Tue, Mar 25, 2014 at 8:36 AM, shahab <shahab.mok...@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 > >