I am running count(*) on table in cqlsh and it is returning different value every time .
cqlsh:keyspace> select count(1) from table_name; count -------- 760912 (1 rows) Warnings : Aggregation query used without partition key cqlsh:keyspace> select count(1) from table_name; count -------- 760901 (1 rows)
I have 3 nodes of cassandra cluster and replication factor = 1 . I believe since rf = 1 , setting consistency does not make any difference ? though setting consistency level = All also giving same issue .