Re: Error on Range queries

[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_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

--
Thanks & Regards,
Himanshu Joshi