incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ryan, Brent" <BR...@cvent.com>
Subject timeuuid and cql3 query
Date Wed, 19 Jun 2013 13:08:45 GMT
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


Mime
View raw message