I am getting a strange exception while using cassandra. Relational operators like (<, >, >=, <=) are not working.
This is the Description of columnfamily
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
