Hi,
I declared this CF:
CREATE TABLE timesliceunitstate (
day timestamp,
unitbuckets text,
PRIMARY KEY (day)
);
unitbuckets is a text column holding a fairly big amount of data, around
30 MB of json text per row.
The table is holding 30 rows, I'm running cassandra 2.0.8 on a 3 nodes
There can be many root causes. Would need a lot more information such as
node hardware specs, cf histograms on the table, tpstats,GC settings (Max
heap, parnew, JVM version) and logs with specifically any ERROR, WARN, or
GCInspector messages
As a start a simple trace of the query in question is