select count(1) and OOM

2013-07-05 Thread Pavel Kirienko
Hi everyone, I was playing with a single-node Cassandra installation when discovered that a request like [SELECT COUNT(*) FROM CF] seems to load the entire dataset of CF into RAM. I am not sure is it expected to behave this way or not. I'd expect it to iterate through the entire set of rows

Re: select count(1) and OOM

2013-07-05 Thread Sylvain Lebresne
I was playing with a single-node Cassandra installation when discovered that a request like [SELECT COUNT(*) FROM CF] seems to load the entire dataset of CF into RAM. This is the case (the whole CF will be loaded in memory). And it's currently a know limitation of Cassandra 1.2. This will be