secondary index on static column

2017-01-27 Thread Micha
Hi, I'm quite new to cassandra and allthough there is much info on the net, sometimes I cannot find the solution to a problem. In this case, I have a second index on a static column and I don't understand the answer I get from my select. A cut down version of the table is: create table demo (id

Re: secondary index on static column

2017-02-02 Thread Romain Hardouin
Hi, What's your C* 3.X version?I've just tested it on 3.9 and it works: cqlsh> SELECT * FROM test.idx_static where id2=22;  id  | added                           | id2 | source | dest-+-+-++-- id1 | 2017-01-27 23:00:00.00+ |  22 |   src1

Re: secondary index on static column

2017-02-02 Thread Micha
Hi, it's a 3.9, installed on a jessie system. For me it's like this: I have a three node cluster. When creating the keyspace with replication factor 3 it works. When creating the keyspace with replication factor 2 it doesn't work and shows the weird behavior. This is a fresh install, I also have

Re: secondary index on static column

2017-02-27 Thread Romain Hardouin
Hi, Sorry for the delay, I created a ticket with steps to reproduce the issue:  https://issues.apache.org/jira/browse/CASSANDRA-13277 Best, Romain Le Jeudi 2 février 2017 16h53, Micha a écrit : Hi, it's a 3.9, installed on a jessie system. For me it's like this: I have a three node cl