I would like to use select count query. Although it was work at Cassandra 1.2.9, but there is a situation which does not work at Cassandra 2.0.0. so, If some row is deleted, 'select count query' seems to return the wrong value. Did anything change by Cassandra 2.0.0 ? or Have I made a mistake ?
My test procedure is as follows: ### At Cassandra 1.2.9 1) create table, and insert two rows ``` cqlsh:test> CREATE TABLE count_hash_test (key text, value text, PRIMARY KEY (key)); cqlsh:test> INSERT INTO count_hash_test (key, value) VALUES ('key1', 'value'); cqlsh:test> INSERT INTO count_hash_test (key, value) VALUES ('key2', 'value'); ``` 2) do a select count query, it returns 2 which is expected ``` cqlsh:test> SELECT * FROM count_hash_test; key | value ------+------- key1 | value key2 | value cqlsh:test> SELECT COUNT(*) FROM count_hash_test; count ------- 2 ``` 3) delete one row ``` cqlsh:test> DELETE FROM count_hash_test WHERE key='key1'; ``` 4) do a select count query, it returns 1 which is expected ``` cqlsh:test> SELECT * FROM count_hash_test; key | value ------+------- key2 | value cqlsh:test> SELECT COUNT(*) FROM count_hash_test; count ------- 1 ``` ### At Cassandra 2.0.0 1) create table, and insert two rows ``` cqlsh:test> CREATE TABLE count_hash_test (key text, value text, PRIMARY KEY (key)); cqlsh:test> INSERT INTO count_hash_test (key, value) VALUES ('key1', 'value'); cqlsh:test> INSERT INTO count_hash_test (key, value) VALUES ('key2', 'value'); ``` 2) do a select count query, it returns 2 which is expected ``` cqlsh:test> SELECT * FROM count_hash_test; key | value ------+------- key1 | value key2 | value cqlsh:test> SELECT COUNT(*) FROM count_hash_test; count ------- 2 ``` 3) delete one row ``` cqlsh:test> DELETE FROM count_hash_test WHERE key='key1'; ``` 4) do a select count query, but it returns 0 which is NOT expected ``` cqlsh:test> SELECT * FROM count_hash_test; key | value ------+------- key2 | value cqlsh:test> SELECT COUNT(*) FROM count_hash_test; count ------- 0 ``` Could anyone help me for this? thanks. Katsutoshi