cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jens Hartung" <ho...@gmx.de>
Subject CQL: No indexed column error when < or <= in WHERE clause
Date Sat, 13 Aug 2011 21:49:39 GMT
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

Mime
View raw message