It's not pattern matching, it's comparing / ordering the byte values. You are asking to return 100 keys in ascending order where the value of the key (after the partitioner has been applied) is greater than "1_265_8_12" 

If you want to do a seek and partial scan, you could use an end value in the list / get_range_slice (e.g. 1_265_8_13) or keep chunking data from the server without an end value and filter / test on the client side. 

Hope that helps.
Aaron
 
On 25 Jan, 2011,at 09:32 AM, Maxim Veksler <[email protected]> wrote:

Hello,

Cassandra is configure as following:

conf/cassandra.yaml | grep 'partitioner:'
partitioner: org.apache.cassandra.dhtByteOrderedPartitioner


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.

Reply via email to