Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of honis@gmx.de designates
 213.165.64.22 as permitted sender)
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset="utf-8"
Date: Sat, 13 Aug 2011 23:49:39 +0200
From: "Jens Hartung" <honis@gmx.de>
In-Reply-To: <1312339364.2893.10.camel@erebus.lan>
Message-ID: <20110813214939.183200@gmx.net>
MIME-Version: 1.0
References: <20110803015822.204140@gmx.net>
 <1312339364.2893.10.camel@erebus.lan>
Subject: CQL: No indexed column error when < or <= in WHERE clause
To: user@cassandra.apache.org

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