?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.