Re: CQL : Date comparison in where clause fails

2013-02-03 Thread Manu Zhang
On Sun 03 Feb 2013 08:19:08 PM CST, Paul van Hoven wrote: 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 mor

Re: CQL : Date comparison in where clause fails

2013-02-03 Thread Paul van Hoven
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 mean

Re: CQL : Date comparison in where clause fails

2013-02-03 Thread Manu Zhang
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'

CQL : Date comparison in where clause fails

2013-02-02 Thread Paul van Hoven
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 th