[
https://issues.apache.org/jira/browse/CASSANDRA-1705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12929117#action_12929117
]
Jonathan Ellis commented on CASSANDRA-1705:
-------------------------------------------
That's not quite right. It needs to be
{code}
UPDATE <CF> [USING CONSISTENCY.<LVL>]
SET <cname1> = <cvalue1>, <cname2> = <cvalue2>, ...
WHERE KEY=<key>
{code}
KEY is mandatory, not just another column. (Nor do we allow arbitrary
expressions.)
Updating more than one row in a batch can be handled with
{code}
BEGIN BATCH
UPDATE ...
UPDATE ...
APPLY BATCH
{code}
Which has the advantage of being able to cover multiple CFs in a single batch
the way the existing API does.
> CQL writes (aka UPDATE)
> -----------------------
>
> Key: CASSANDRA-1705
> URL: https://issues.apache.org/jira/browse/CASSANDRA-1705
> Project: Cassandra
> Issue Type: Sub-task
> Components: API
> Affects Versions: 0.8
> Reporter: Eric Evans
> Priority: Minor
> Fix For: 0.8
>
> Original Estimate: 0h
> Remaining Estimate: 0h
>
> CQL specification and implementation for data manipulation.
> This corresponds to the following RPC methods:
> * insert()
> * batch_mutate() (writes, not deletes)
> The initial check-in to trunk/ uses a syntax that looks like:
> {code:SQL}
> UPDATE <CF> [USING CONSISTENCY.<LVL>] WITH ROW(<key>, COLUMN(<name>,
> <value>)[, COLUMN(...)])[ AND ROW(...)];
> {code}
> Where:
> * <CF> is the column family name.
> * Rows are a parenthesized expressions with comma separated arguments for a
> key and one or more columns.
> * Columns are a parenthesized expressions with comma separated arguments for
> the name and value (timestamp is inaccessible).
> What is still undone:
> * Complete test coverage
> And of course, all of this is still very much open to further discussion.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
