cqlsh:demo> create table testtable(id bigint primary key, id2 bigint );
cqlsh:demo> create index xxx on testtable(id2);

cqlsh:demo> select * from testtable;


cqlsh:demo> select count(*) from testtable;
 count
-------
     0

!!! Это правильно!

cqlsh:demo> select count(*) from testtable where id=1;
 count
-------
     1

ПОЧЕМУ?????!

cqlsh:demo> select * from testtable where id=1;
 id
----
  1


???? ОТКУДА??)))

cqlsh:log> select count(*) from testtable where id>0;
 count
-------
     0

!! и снова все верно

cqlsh:log>