cassandra - Slicing over partition rows using tuple operation in CQL -
i trying understand behavior of tuple operator clustering keys. here trying do: create table sampletable (a int,b int,c int, d int, e int, primary key((a,b,c),d,e)); insert sampletable(a,b,c,d,e) values(1,1,1,1,1); insert sampletable(a,b,c,d,e) values(1,1,1,1,1); insert sampletable(a,b,c,d,e) values(1,1,1,1,2); insert sampletable(a,b,c,d,e) values(1,1,2,1,1); insert sampletable(a,b,c,d,e) values(1,1,2,1,2); insert sampletable(a,b,c,d,e) values(1,1,2,2,3); insert sampletable(a,b,c,d,e) values(1,1,2,1,2); insert sampletable(a,b,c,d,e) values(1,1,1,2,3); cqlsh:mapro> select * sampletable; | b | c | d | e ---+---+---+---+--- 1 | 1 | 1 | 1 | 1 1 | 1 | 1 | 1 | 2 1 | 1 | 1 | 2 | 3 1 | 1 | 2 | 1 | 1 1 | 1 | 2 | 1 | 2 1 | 1 | 2 | 2 | 3 (6 rows) -- query1 cqlsh:mapro> select * sampletable a=1 , b=1 , c in (1,2) , (d,e)<(2,3); | b | c | d | e ---+---+---+---+--- ...