Re: Why is our range query failing in Cassandra 0.8.10 Client

2012-07-12 Thread Sylvain Lebresne
When executing a query like: get events WHERE Firm=434550 AND ds_timestamp>=1341955958200 AND ds_timestamp<=1341955958200; what the 2ndary index implementation will do is: 1) it queries the index for Firm for the row with key 434550 (because that's the only one restricted by an equal clause, and

Why is our range query failing in Cassandra 0.8.10 Client

2012-07-11 Thread JohnB
Hi: We are currently using Cassandra 0.8.10 and have run into some strange issues surrounding querying for a range of data I ran a couple of get statements via the Cassandra client and found some interesting results: Consider the following Column Family Definition: ColumnFamily: event