incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thamizh <tceg...@yahoo.co.in>
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.

Emp(KS){
    User(CF):{
        bsanderson(RowKey): { eno, name, dept, dob, email }
        prothfuss(RowKey): { eno, name, dept, dob, email }
            }
        }

Queries,

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.

Regards,
Thamizhananl
Mime
View raw message