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

2013-01-31 Thread Sylvain Lebresne
birth_year is secondary indexed. When querying using 2nd indexes, Cassandra (it's not CQL specific) requires that you use an '=' for at least one of the indexed column in the where clause (in your example you only have one such column so it should be an '='). This is a limitation of 2ndary indexes

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

2013-01-31 Thread Dinusha Dilrukshi
Thanks Sylvain.. Regards, Dinusha. On Thu, Jan 31, 2013 at 2:47 PM, Sylvain Lebresne sylv...@datastax.comwrote: birth_year is secondary indexed. When querying using 2nd indexes, Cassandra (it's not CQL specific) requires that you use an '=' for at least one of the indexed column in the

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

2013-01-30 Thread 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},