incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Kerzner <markkerz...@gmail.com>
Subject Re: Secondary indices with multiple conditions?
Date Fri, 10 Jun 2011 05:53:50 GMT
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 <jbellis@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 <markkerzner@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
>

Mime
View raw message