Hi,
I have a second index on a static column and I don't
understand the answer I get from my select.
Maybe someone who understands the inner working of the second index can
give me a hint on this (cassandra 3.9)
A cut down version of the table is:
create table demo (id text, id2 bigint static, added timestamp, source
text static, dest text, primary key (id, added));
create index on demo (id2);
id and id2 match one to one.
I make one insert:
insert into demo (id, id2, added, source, dest) values ('id1', 22,
'2017-01-28', 'src1', 'dst1');
The "select from demo;" gives the expected answer of the one inserted row.
But "select from demo where id2=22" gives 70 rows as result (all the same).
Why? I have read
https://www.datastax.com/dev/blog/cassandra-native-secondary-index-deep-dive
but I don't get it...
thanks for helping
Michael
