title: Cassandra BETWEEN & ORDER BY operations
body: <p>I wanted to perform SQL operations such as BETWEEN, ORDER BY with ASC/DSC order on Cassandra-0.7.8.</p>
  
  <p>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?</p>
  
  <p>Below is my Data model design.</p>
  
  <pre><code>Emp(KS){
      User(CF):{
           bsanderson(RowKey): { eno, name, dept, dob, email }
       prothfuss(RowKey): { eno, name, dept, dob, email }
  }
  }
  </code></pre>
  
  <p>Queries:</p>
  
  <pre><code> - Select * from emp where dept='IT' ORDER BY dob ASC. 
   - Select * from emp where eno BETWEEN ? AND ? ORDER BY dob ASC.
  </code></pre>
  
  <p>Thanks in advance.</p>
  
  <p>Regards,</p>
  
  <p>Thamizhananl</p>