incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thamizh <>
Subject Cassandra BETWEEN & ORDER BY operations
Date Wed, 31 Aug 2011 10:36:37 GMT
Hi All,

I wanted to perform SQL operations such as BETWEEN, ORDER BY with ASC/DSC order on Cassandra-0.7.8.

As I know, Cassandra-0.7.8 does not have direct support to these operations. Kindly let me
know is there a way to accomplish these by tweaking on secondary index?

Below is my Data model design.

        bsanderson(RowKey): { eno, name, dept, dob, email }
        prothfuss(RowKey): { eno, name, dept, dob, email }


1. Select * from emp where dept='IT' ORDER BY dob ASC

2. Select * from emp where eno BETWEEN ? AND ? ORDER BY dob ASC;

Thanks in advance.

View raw message