Jon, It's 2.1.10. I will see if I can reproduce it with a simple script.
Thanks. On Fri, Oct 23, 2015 at 1:05 PM, Jon Haddad <j...@jonhaddad.com> wrote: > 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 > >
