I had indexed the 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 < 8210;" I'll get mentioned exception. Is there something, that I misunderstand? -------- Original-Nachricht -------- > Datum: Sat, 13 Aug 2011 18:14:05 -0700 > Von: Jonathan Ellis <jbel...@gmail.com> > An: user@cassandra.apache.org > Betreff: Re: CQL: No indexed column error when < or <= in WHERE clause > 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 <ho...@gmx.de> 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, everything > works fine, but when using <= or < in WHERE clause, I always get following > Exception: > > > > java.sql.SQLException: No indexed columns present in by-columns clause > with "equals" operator > > at > org.apache.cassandra.cql.jdbc.CassandraStatement.executeQuery(CassandraStatement.java:242) > > at > columnfamily.queries.CassandraQueries.singleColumnSelect(CassandraQueries.java:147) > > ... > > > > My select-statement: "SELECT number FROM station WHERE number <= 8210;" > > > > Output of describe keyspace (within cli): > > ColumnFamily: station > > Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type > > Default column value validator: > org.apache.cassandra.db.marshal.UTF8Type > > Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type > > Row cache size / save period in seconds: 0.0/0 > > Key cache size / save period in seconds: 200000.0/14400 > > Memtable thresholds: 0.2109375/1440/45 (millions of > ops/minutes/MB) > > GC grace seconds: 864000 > > Compaction min/max thresholds: 4/32 > > Read repair chance: 1.0 > > Replicate on write: true > > Built indexes: [station.station_number_idx] > > Column Metadata: > > [...] > > Column Name: number > > Validation Class: org.apache.cassandra.db.marshal.LongType > > Index Name: station_number_idx > > Index Type: KEYS > > [...] > > > > Are the <, <=, >=, > operators not supported at this time? > > > > Greetings > > Jens > > -- > > NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie! > > Jetzt informieren: http://www.gmx.net/de/go/freephone > > > > > > -- > Jonathan Ellis > Project Chair, Apache Cassandra > co-founder of DataStax, the source for professional Cassandra support > http://www.datastax.com -- NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie! Jetzt informieren: http://www.gmx.net/de/go/freephone
