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