I'm experimenting with a data model that will need to ingest a lot of data that
will need to be query able by time. In the example below, I want to be able to
run a query like "select * from count3 where counter = 'test' and ts >
minTimeuuid('2013-06-18 16:23:00') and ts < minTimeuuid('2013-06-18
16:24:00');". However, in certain cases this query fails with the error "Bad
Request: Start key must sort before (or equal to) finish key in your
partitioner!". It's not clear to be why this happens or what the issue is as
it seems like a bug.
Here's the table:
CREATE TABLE count3 (
counter text,
ts timeuuid,
key1 text,
value int,
PRIMARY KEY ((counter, ts))
)
It has data like so:
cqlsh:Statistics> select counter,dateof(ts),key1,value from count3;
counter | dateof(ts) | key1 | value
---------+--------------------------+------+-------
test | 2013-06-18 16:23:25-0400 | 1 | 1
test | 2013-06-18 16:23:28-0400 | 1 | 1
test | 2013-06-18 16:23:28-0400 | 1 | 1
test | 2013-06-18 16:23:28-0400 | 1 | 1
test | 2013-06-18 16:23:29-0400 | 1 | 1
test | 2013-06-18 16:23:29-0400 | 1 | 1
test | 2013-06-18 16:23:29-0400 | 1 | 1
test | 2013-06-18 16:23:30-0400 | 1 | 1
test | 2013-06-18 16:23:30-0400 | 1 | 1
test | 2013-06-18 16:23:31-0400 | 1 | 1
test | 2013-06-18 16:23:31-0400 | 1 | 1
test | 2013-06-18 16:23:31-0400 | 1 | 1
test | 2013-06-18 16:23:32-0400 | 1 | 1
test | 2013-06-18 16:23:32-0400 | 1 | 1
DOESN'T WORK:
cqlsh:Statistics> select * from count3 where counter = 'test' and ts >
minTimeuuid('2013-06-18 16:23:00') and ts < minTimeuuid('2013-06-18 16:24:00');
Bad Request: Start key must sort before (or equal to) finish key in your
partitioner!
WORKS FINE:
cqlsh:Statistics> select * from count3 where counter = 'test' and ts >
minTimeuuid('2013-06-18 16:23:25') and ts < minTimeuuid('2013-06-18 16:23:31');
counter | ts | key1 | value
---------+--------------------------------------+------+-------
test | edee0df0-d854-11e2-ac46-cba9e55f995d | 1 | 1
test | ef9a5e60-d854-11e2-ac46-cba9e55f995d | 1 | 1
test | efccb900-d854-11e2-ac46-cba9e55f995d | 1 | 1
test | effb1c00-d854-11e2-ac46-cba9e55f995d | 1 | 1
test | f0284680-d854-11e2-ac46-cba9e55f995d | 1 | 1
test | f05b8b80-d854-11e2-ac46-cba9e55f995d | 1 | 1
test | f08c5f80-d854-11e2-ac46-cba9e55f995d | 1 | 1
test | f0c6f780-d854-11e2-ac46-cba9e55f995d | 1 | 1
test | f1018f80-d854-11e2-ac46-cba9e55f995d | 1 | 1
Thanks,
Brent
