Error when using CQL driver : No indexed columns present in by-columns clause with "equals" operator

[Dinusha Dilrukshi]

Hi All,

I have created a column family as follows. (With secondary indexes.)

create column family users with comparator=UTF8Type and
key_validation_class = 'UTF8Type' and default_validation_class = 'UTF8Type'
 and column_metadata=[{column_name: full_name, validation_class: UTF8Type},
 {column_name: birth_year, validation_class: LongType, index_type: KEYS},
 {column_name: state, validation_class:  UTF8Type, index_type: KEYS}];

And I am using CQL driver-1.1.1 with Cassandra server-1.1.1. Once I try to
execute the following query, it gives  an exception saying 'No indexed
columns present in by-columns clause with "equals" operator'.

CQL :
select * from users where birth_year<1965

Caused by: java.sql.SQLSyntaxErrorException: No indexed columns present in
by-columns clause with "equals" operator
    at
org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.doExecute(CassandraPreparedStatement.java:155)
    at
org.apache.cassandra.cql.jdbc.CassandraPreparedStatement.executeQuery(CassandraPreparedStatement.java:199)

Appreciate any help to resolve this..

Regards,
Dinusha.