Re: Error on Range queries

2013-05-06 Thread himanshu.joshi
Thanks aaron.. -- Regards Himanshu Joshi On 05/06/2013 02:22 PM, aaron morton wrote: "Bad Request: No indexed columns present in by-columns clause with Equal operator Perhaps you meant to use CQL 2? Try using the -2 option when starting cqlsh." My query is: select * from temp where min_updat

Re: Error on Range queries

2013-05-06 Thread aaron morton
> "Bad Request: No indexed columns present in by-columns clause with Equal > operator > Perhaps you meant to use CQL 2? Try using the -2 option when starting cqlsh." > > My query is: select * from temp where min_update >10 limit 5; You have to have at least one indexes column in the where clause

Error on Range queries

2013-05-03 Thread himanshu.joshi
Hi, I have created a 2 node test cluster in Cassandra version 1.2.3 with Simple Strategy, Replication Factor 2 and ByteOrderedPartitioner(so as to get Range Query functionality). When i am using a range query on a secondary index in CQLSH, I am getting the error : "Bad Request: No in