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