Re: The way to query a CF with "start > 10 and end < 100"

2011-08-29 Thread Benoit Perroud
queries start > 10 and end < 100 is not straight forward to modelize, you should use the value of start as column name, and check on client side the second condition. Just for comparison, modeling 10 < value < 100 is rather much easier if you set your values as column name, or using CompositeType

The way to query a CF with "start > 10 and end < 100"

2011-08-29 Thread Guofeng Zhang
Hi, I have a standard CF that has column "start" and "end". I need to query its rows using condition "start>10 and end<100". Is there any better way to do it? Using native secondary index or creating a specific CF for the search. I do not know which one is better. If the late is preferred to, h