Thanks. Thats work. Why an Equal restriction is required? 2013/2/28 Jason Wee <peich...@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.inu...@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
