cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cathy Daw (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-2567) CQL: DELETE documentation uses UPDATE examples
Date Tue, 26 Apr 2011 20:17:03 GMT
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

Mime
View raw message