You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Cathy Daw (JIRA)" <ji...@apache.org> on 2011/04/26 22:17:03 UTC
[jira] [Created] (CASSANDRA-2567) CQL: DELETE documentation uses
UPDATE examples
CQL: DELETE documentation uses UPDATE examples
----------------------------------------------
Key: CASSANDRA-2567
URL: https://issues.apache.org/jira/browse/CASSANDRA-2567
Project: Cassandra
Issue Type: Bug
Affects Versions: 0.8 beta 1
Reporter: Cathy Daw
Priority: Trivial
{panel}
h2. DELETE
_Synopsis:_
bc.
DELETE [COLUMNS] FROM <COLUMN FAMILY> [USING <CONSISTENCY>] WHERE KEY = keyname1
DELETE [COLUMNS] FROM <COLUMN FAMILY> [USING <CONSISTENCY>] WHERE KEY IN (keyname1, keyname2);
A @DELETE@ is used to perform the removal of one or more columns from one or more rows.
h3. Specifying Columns
bc.
DELETE [COLUMNS] ...
Following the @DELETE@ keyword is an optional comma-delimited list of column name terms. When no column names are specified, the remove applies to the entire row(s) matched by the "WHERE clause":#deleterows
h3. Column Family
bc.
DELETE ... FROM <COLUMN FAMILY> ...
The column family name follows the list of column names.
h3. Consistency Level
bc.
UPDATE ... [USING <CONSISTENCY>] ...
Following the column family identifier is an optional "consistency level specification":#consistency.
h3(#deleterows). Specifying Rows
bc.
UPDATE ... WHERE KEY = keyname1
UPDATE ... WHERE KEY IN (keyname1, keyname2)
The @WHERE@ clause is used to determine which row(s) a @DELETE@ applies to. The first form allows the specification of a single keyname using the @KEY@ keyword and the @=@ operator. The second form allows a list of keyname terms to be specified using the @IN@ notation and a parenthesized list of comma-delimited keyname terms.
{panel}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (CASSANDRA-2567) CQL: DELETE documentation uses
UPDATE examples
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-2567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis resolved CASSANDRA-2567.
---------------------------------------
Resolution: Fixed
Fix Version/s: 0.8.0
fixed in r1096915
> CQL: DELETE documentation uses UPDATE examples
> ----------------------------------------------
>
> Key: CASSANDRA-2567
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2567
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 0.8 beta 1
> Reporter: Cathy Daw
> Priority: Trivial
> Labels: cql
> Fix For: 0.8.0
>
>
> {panel}
> h2. DELETE
> _Synopsis:_
> bc.
> DELETE [COLUMNS] FROM <COLUMN FAMILY> [USING <CONSISTENCY>] WHERE KEY = keyname1
> DELETE [COLUMNS] FROM <COLUMN FAMILY> [USING <CONSISTENCY>] WHERE KEY IN (keyname1, keyname2);
> A @DELETE@ is used to perform the removal of one or more columns from one or more rows.
> h3. Specifying Columns
> bc.
> DELETE [COLUMNS] ...
> Following the @DELETE@ keyword is an optional comma-delimited list of column name terms. When no column names are specified, the remove applies to the entire row(s) matched by the "WHERE clause":#deleterows
> h3. Column Family
> bc.
> DELETE ... FROM <COLUMN FAMILY> ...
> The column family name follows the list of column names.
> h3. Consistency Level
> bc.
> UPDATE ... [USING <CONSISTENCY>] ...
> Following the column family identifier is an optional "consistency level specification":#consistency.
> h3(#deleterows). Specifying Rows
> bc.
> UPDATE ... WHERE KEY = keyname1
> UPDATE ... WHERE KEY IN (keyname1, keyname2)
> The @WHERE@ clause is used to determine which row(s) a @DELETE@ applies to. The first form allows the specification of a single keyname using the @KEY@ keyword and the @=@ operator. The second form allows a list of keyname terms to be specified using the @IN@ notation and a parenthesized list of comma-delimited keyname terms.
>
> {panel}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira