Like the exception says:
> Bad Request: No indexed columns present in by-columns clause with "equals" operator
> Same with other relational operators(<,>=,<=)
You must include an equality operator in the where clause:
That is why
> SELECT * FROM STEST WHERE VALUE1 = 10;
Works but
> SELECT * FROM STEST WHERE VALUE1 > 10;
does not.
Cheers
-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 28/06/2012, at 8:55 PM, Abhijit Chanda wrote:
> Hi All,
> I have got a strange exception while using cassandra cql. Relational operators like (<,
>, >=, <=) are not working.
> my columnfamily looks like this.
> CREATE COLUMNFAMILY STEST (
> ROW_KEY text PRIMARY KEY,
> VALUE1 text,
> VALUE2 text
> ) WITH
> comment='' AND
> comparator=text AND
> read_repair_chance=0.100000 AND
> gc_grace_seconds=864000 AND
> default_validation=text AND
> min_compaction_threshold=4 AND
> max_compaction_threshold=32 AND
> replicate_on_write=True;
>
> CREATE INDEX VALUE1_IDX ON STEST (VALUE1);
>
> CREATE INDEX VALUE2_IDX ON STEST (VALUE2);
>
>
> Now in this columnfamily if i query this
> SELECT * FROM STEST WHERE VALUE1 = 10; it returns ----->
> ROW_KEY | VALUE1 | VALUE2
> ---------+-------------+------------
> 2 | 10 | AB
>
> But if i query like this
> SELECT * FROM STEST WHERE VALUE1 > 10;
> It is showing this exception
> Bad Request: No indexed columns present in by-columns clause with "equals" operator
> Same with other relational operators(<,>=,<=)
>
> these are the datas available in my columnfamily
> ROW_KEY | VALUE1 | VALUE2
> ----------------+--------------+--------
> 3 | 100 | ABC
> 5 | 9 | ABCDE
> 2 | 10 | AB
> 1 | 1 | A
> 4 | 19 | ABCD
>
> Looks like some configuration problem. Please help me. Thanks in Advance
>
>
>
>
> Regards,
> --
> Abhijit Chanda
> Analyst
> VeHere Interactive Pvt. Ltd.
> +91-9748888395
>
|