incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Everton Lima <peitin.inu...@gmail.com>
Subject Re: Problem with CQL
Date Thu, 28 Feb 2013 17:51:11 GMT
Thanks. Thats work.
Why an Equal restriction is required?

2013/2/28 Jason Wee <peichieh@gmail.com>

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


-- 
Everton Lima Aleixo
Bacharel em Ciência da Computação pela UFG
Mestrando em Ciência da Computação pela UFG
Programador no LUPA

Mime
View raw message