?Having been pointed to https://issues.apache.org/jira/browse/CASSANDRA-1704 I wanted to know what the state of that was. Eric Evans said changes had been pushed to SVN, can I check out the latest head and play with it?

Looking at the comments, if its not too late here's my 2cents.
For what it's worth I think CQL will be useful.

SELECT COL1,COL2 FROM CF WHERE ROWKEY=KEY1

In this semantics we can specify the columns we we're interested in.
Secondly allowing the predicate to specify a row key to start from...


SELECT COL1 TO COL20 FROM CF WHERE ROWKEY=KEY1 TO KEY1000

COL1 TO COL20 obviously specifies the range of columns we'd like back and key1 to key1000 specifies our rows.

While I think CQL will be nice to have I agree with some of the points brought up. In the proposal there was ASC and DESC on the end of the query template, assuming here that this implies being able to sort records. I don't believe this would be beneficial since the already established ethos is to have data sorted prior to querying for the obvious reason.

Being able to use an SQL like syntax should be a matter of convenience and only where it will not force incompatibilities.

Reply via email to