Hello, Cassandra is configure as following:
conf/cassandra.yaml | grep 'partitioner:' partitioner: org.apache.cassandra.dht.ByteOrderedPartitioner Why yet doing range query on part of the key return more results then expected (column, CF and keyspace names masked): [default@KEYSPACE] list CF1[1_265_8_12:]; Using default limit of 100 ------------------- RowKey: 1_265_8_12_45 .... ------------------- RowKey: 1_265_8_12_46 .... ------------------- RowKey: 1_265_8_12_47 .... ------------------- RowKey: 1_265_8_12_48 .... ------------------- RowKey: 1_265_8_33_129 .... ------------------- RowKey: 1_265_8_33_130 .... ------------------- RowKey: 1_265_8_33_131 .... ------------------- RowKey: 1_265_8_33_132 .... ------------------- RowKey: 1_265_8_53_206 .... ------------------- RowKey: 1_265_8_53_207 .... ------------------- RowKey: 1_265_8_53_208 .... ------------------- RowKey: 1_265_8_53_209 .... ------------------- RowKey: 1_265_8_5_17 .... ------------------- RowKey: 1_265_8_5_18 .... ------------------- RowKey: 1_265_8_5_19 .... ------------------- RowKey: 1_265_8_5_20 .... ------------------- RowKey: 1_265_8_6_21 .... ------------------- RowKey: 1_265_8_6_22 .... ------------------- RowKey: 1_265_8_6_23 .... ------------------- RowKey: 1_265_8_6_24 .... 20 Rows Returned. I would expect only keys RowKey: *1_265_8_12*_45, *1_265_8_12*_46, * 1_265_8_12*_47, *1_265_8_12*_48 to be returned because they are the only ones that (to my understanding) should match the pattern [*1_265_8_12*:]. What am I missing? The same behavior happens both with cassandra-cli and hector... Thank you, Maxim.