What version of Cassandra? I can’t think of a reason why you’d see this output. If you can reliably reproduce, this should be filed as a JIRA. https://issues.apache.org/jira
> On Oct 23, 2015, at 8:55 AM, Kai Wang <dep...@gmail.com> wrote: > > Hi, > > I use a timestamp column as the last clustering key so that I can run query > like "timestamp > ... AND timestamp < ...". But it doesn't work as expected. > Here is a simplified example. > > My table: > CREATE TABLE test ( > tag text, > group int, > timestamp timestamp, > value double, > PRIMARY KEY (tag, group, timestamp) > ) WITH CLUSTERING ORDER BY (group ASC, timestamp DESC) > > After inserting some data, here is my query: > > cqlsh> select * from test where tag = 'MSFT' and group = 1 and timestamp > ='2004-12-15 16:00:00-0500'; > > tag | group | timestamp | value > ------+-------+--------------------------+------- > MSFT | 1 | 2004-12-15 21:00:00+0000 | 27.11 > MSFT | 1 | 2004-12-16 21:00:00+0000 | 27.16 > MSFT | 1 | 2004-12-17 21:00:00+0000 | 26.96 > MSFT | 1 | 2004-12-20 21:00:00+0000 | 26.95 > MSFT | 1 | 2004-12-21 21:00:00+0000 | 27.07 > MSFT | 1 | 2004-12-22 21:00:00+0000 | 26.98 > MSFT | 1 | 2004-12-23 21:00:00+0000 | 27.01 > MSFT | 1 | 2004-12-27 21:00:00+0000 | 26.85 > MSFT | 1 | 2004-12-28 21:00:00+0000 | 26.95 > MSFT | 1 | 2004-12-29 21:00:00+0000 | 26.9 > MSFT | 1 | 2004-12-30 21:00:00+0000 | 26.76 > (11 rows) > > This doesn't make sense. I expect this query to return only the first row. > Why does it give me back rows with different timestamps? Did I misunderstand > how timestamp and clustering key work? > > Thanks. > > -Kai