cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Everton Lima <>
Subject Problem with CQL
Date Thu, 28 Feb 2013 14:04:56 GMT
I was using cql 2. I have the following query:
   SELECT * FROM users WHERE age > 20 AND age < 25;

The table was created as follow:
   CREATE TABLE users (name PRIMARY KEY, age float);

After create table and insert some data I create the Secondary Index:
   CREATE INDEX age_index ON users (age);

When I execute a query like:
    SELECT * FROM users WHERE age = 22;
it works fine. But when I try something like this:
    SELECT * FROM users WHERE age > 20
I recieve the error:
    Bad Request: No indexed columns present in by-columns clause with
"equals" operator

Someone can help me, please?
Everton Lima Aleixo
Mestrando em Ciência da Computação pela UFG
Programador no LUPA

View raw message