incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manu Zhang <owenzhang1...@gmail.com>
Subject Re: CQL : Date comparison in where clause fails
Date Sun, 03 Feb 2013 09:38:32 GMT
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.

Mime
View raw message