cassandra secondary index with

2012-06-19 Thread Yuhan Zhang
Hi all, I'm trying to search by the secondary index of cassandra with "greater than or equal". but reached an exception stating: me.prettyprint.hector.api.exceptions.HInvalidRequestException: InvalidRequestException(why:No indexed columns present in index clause with operator EQ) However, the sam

Re: cassandra secondary index with

2012-06-19 Thread Yuhan Zhang
To anwser my own question: There should be at least on "equal" expression in the indexed query to combine with a "gte". so, I just added an trivial column that stays constant for equal comparison. and it works. not sure why this requirement exists. Thank you. Yuhan On Tue, Jun 19, 2012 at 12:2

Re: cassandra secondary index with

2012-06-19 Thread Jonathan Ellis
That this will get you *worse* performance than just doing a seq scan would. Details as to why this is, are here: http://www.datastax.com/dev/blog/whats-new-cassandra-07-secondary-indexes On Tue, Jun 19, 2012 at 2:48 PM, Yuhan Zhang wrote: > To anwser my own question: > > There should be at leas

Re: cassandra secondary index with

2012-06-19 Thread Yuhan Zhang
Hi Jonathan, thanks for the reference. will read up on it. Yuhan