incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Katsutoshi <nagapad.0...@gmail.com>
Subject select count query not working at cassandra 2.0.0
Date Fri, 20 Sep 2013 06:07:37 GMT
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

Mime
View raw message