On Sun 03 Feb 2013 07:36:58 AM CST, Paul van Hoven wrote:
I've got a table that has a column called date. I created an index on
the column date with the following command:
CREATE INDEX date_key ON ola (date);
Now, I can perform the following command:
select * from ola where date = '2013-01-01' limit 10;
The results are correctly displayed.
But the the following command fails:
cqlsh:demodb> select * from ola where date > '2013-01-01' limit 10;
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.
The same happens when using
cqlsh:demodb> select * from ola where date >= '2013-01-01' limit 10;
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.
Why does this happen?
because only EQ operator is allowed. There is a similar question in an
earlier thread, and as pointed out by Sylvain,
https://issues.apache.org/jira/browse/CASSANDRA-4476 may finally solve
it.
