> "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 that uses the equal operator.
Cheers ----------------- Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 4/05/2013, at 1:22 AM, himanshu.joshi <himanshu.jo...@orkash.com> wrote: > 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 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; > > > > My table structure is: > > CREATE TABLE temp ( > id bigint PRIMARY KEY, > archive_name text, > country_name text, > description text, > dt_stamp timestamp, > location_id bigint, > max_update bigint, > min_update bigint > ) WITH COMPACT STORAGE AND > bloom_filter_fp_chance=0.010000 AND > caching='KEYS_ONLY' AND > comment='' AND > dclocal_read_repair_chance=0.000000 AND > gc_grace_seconds=864000 AND > read_repair_chance=0.100000 AND > replicate_on_write='true' AND > populate_io_cache_on_flush='false' AND > compaction={'class': 'SizeTieredCompactionStrategy'} AND > compression={'sstable_compression': 'SnappyCompressor'}; > > CREATE INDEX temp_min_update_idx ON temp (min_update); > > > Range queries are working fine on primary key. > > > I am getting the same error on another query of an another table temp2: > > select * from temp2 where reffering_url='Some URL'; > > this table is also having the secondary index on this field("reffering_url") > > Any help would be appreciated. > -- > Thanks & Regards, > Himanshu Joshi >
