You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by "himanshu.joshi" <hi...@orkash.com> on 2013/05/03 15:22:05 UTC
Error on Range queries
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
Re: Error on Range queries
Posted by "himanshu.joshi" <hi...@orkash.com>.
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 <hi...@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
Re: Error on Range queries
Posted by aaron morton <aa...@thelastpickle.com>.
> "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 <hi...@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
>