Re: CQL: No indexed column error when < or <= in WHERE clause

2011-08-14 Thread Jens Hartung
assandra.apache.org > Betreff: Re: CQL: No indexed column error when < or <= in WHERE clause > This will be fully solved with CASSANDRA-2915 which will use Lucene as > a the secondary index type implementation. Lucene has extremely fast > range queries built in. > > On Sun,

Re: CQL: No indexed column error when < or <= in WHERE clause

2011-08-14 Thread Jason Rutherglen
he number column in station column family. Do I also have >> > to index another column? >> > >> > What I'm wondering, when I type "get station where number = 8210;" all >> > works fine, but when I type "get station where number &

Re: CQL: No indexed column error when < or <= in WHERE clause

2011-08-14 Thread Sal Fuentes
olumn? > > > > What I'm wondering, when I type "get station where number = 8210;" all > works fine, but when I type "get station where number < 8210;" I'll get > mentioned exception. > > > > Is there something, that I misunderstand? &g

Re: CQL: No indexed column error when < or <= in WHERE clause

2011-08-14 Thread Martin von Zweigbergk
where number = 8210;" all works > fine, but when I type "get station where number < 8210;" I'll get mentioned > exception. > > Is there something, that I misunderstand? > > Original-Nachricht >> Datum: Sat, 13 Aug 2011 18:14:05 -07

Re: CQL: No indexed column error when < or <= in WHERE clause

2011-08-14 Thread Jens Hartung
tion. Is there something, that I misunderstand? Original-Nachricht > Datum: Sat, 13 Aug 2011 18:14:05 -0700 > Von: Jonathan Ellis > An: user@cassandra.apache.org > Betreff: Re: CQL: No indexed column error when < or <= in WHERE clause > This is covered in >

Re: CQL: No indexed column error when < or <= in WHERE clause

2011-08-13 Thread Jonathan Ellis
This is covered in http://www.datastax.com/dev/blog/whats-new-cassandra-07-secondary-indexes On Sat, Aug 13, 2011 at 2:49 PM, Jens Hartung wrote: > Hi together, > > first, I'm using Cassandra Version 0.8.4 and access it via CQL 1.0.3. > > When I select data from Cassandra with = in WHERE clause,

CQL: No indexed column error when < or <= in WHERE clause

2011-08-13 Thread Jens Hartung
Hi together, first, I'm using Cassandra Version 0.8.4 and access it via CQL 1.0.3. When I select data from Cassandra with = in WHERE clause, everything works fine, but when using <= or < in WHERE clause, I always get following Exception: java.sql.SQLException: No indexed columns present in by-c