CQL 3 in Cassandra 1.2 does not allow order by when it is a wide row and a column with secondary index is used in a where clause which makes sense. So the question is:
I have a test table like this: CREATE TABLE test( interval int, id uuid, severity int, PRIMARY KEY (interval, id)) WITH CLUSTERING ORDER BY (id DESC); -- CREATE INDEX ON test(severity); -- In my test case the result of the following query which always has row key in the where clause, is always ordered by id select * from test where interval = 7 and severity = 3; Can I always count on this order, or it may change in the future? Thanks in Advance Shahryar -- "Life is what happens while you are making other plans." ~ John Lennon