Thanks for the answer. If I understand that correctly I had to do the following to repair my query:
cqlsh:demodb> select * from ola where date < '2013-01-01' and date = '2013-01-01' limit 10; Bad Request: datum cannot be restricted by more than one relation if it includes an Equal Perhaps you meant to use CQL 2? Try using the -2 option when starting cqlsh. So, this still fails. Therefore I'm not shure whether I missunderstand the issue or if it does not solve my problem. 2013/2/3 Manu Zhang <owenzhang1...@gmail.com>: > 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.