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

Reply via email to