So in Hector I can do, for example, addGtExpression any number of times, correct?
Internally, how is it implemented? Do we get the subset of data based on an indexed columns, and then essentially scan the rest, with Cassandra API or Hector providing filtering. So this may be an expensive operation? For example, how long would you expect 1 million rows and 10 conditions to take? Thank you very much, very helpful. Mark On Thu, Jun 9, 2011 at 10:28 PM, Jonathan Ellis <jbel...@gmail.com> wrote: > Yes, with the restriction that at least one of the conditions must be > = on an indexed column. > > See > http://www.datastax.com/dev/blog/whats-new-cassandra-07-secondary-indexes > for an example. > > On Thu, Jun 9, 2011 at 9:53 PM, Mark Kerzner <markkerz...@gmail.com> > wrote: > > Hi, > > if I am using Cassandra's secondary indices, or even if I am doing it > myself > > following Ed Anuff's advice, can I do multiple slices? That is, how do I > > imitate a SQL query of > > where column_1 > 5 and column_2 < 4 and so on, up to dozens of > conditions? > > Thank you, > > Mark > > > > -- > Jonathan Ellis > Project Chair, Apache Cassandra > co-founder of DataStax, the source for professional Cassandra support > http://www.datastax.com >
