incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jason Wee <peich...@gmail.com>
Subject Re: Problem with CQL
Date Thu, 28 Feb 2013 14:46:13 GMT
You need an equal operator in your query. For instance,   SELECT * FROM
users WHERE country = 'malaysia' age > 20


On Thu, Feb 28, 2013 at 10:04 PM, Everton Lima <peitin.inutil@gmail.com>wrote:

> Hello,
> 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
>
>

Mime
View raw message