[
https://issues.apache.org/jira/browse/CASSANDRA-6292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sylvain Lebresne resolved CASSANDRA-6292.
-----------------------------------------
Resolution: Duplicate
> CQL should be able to do a delete with a > or < operator on a clustering
> portion of a primary key
> --------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-6292
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6292
> Project: Cassandra
> Issue Type: Improvement
> Components: API
> Reporter: Tupshin Harper
> Assignee: Jonathan Ellis
> Fix For: 2.1
>
>
> The following creates a table that at the storage engine level, has "key" as
> the row key, and evt as a time ordered list of columns within the row:
> create table test (key text, evt timestamp, primary key(key,evt)) with
> clustering order by (evt asc);
> Given the ability to create slice tombstones (both implicitly by deleting
> collections and supercolumns) as well as in thrift through a delete with a
> slice predicate.
> Given the schema above, the expected syntax to delete all columns with key
> "one" and timestamp less than 1000 would be:
> delete from test where key='one' and evt < 1000;
> and if you did that as well as
> delete from test where key='one' and evt > 1000;
> You would accomplish exactly what is being asked about (in terms of thrift
> and astyanax) here:
> http://stackoverflow.com/questions/19747005/delete-all-the-columns-and-its-data-except-for-one-columns-using-astyanax-client
--
This message was sent by Atlassian JIRA
(v6.1#6144)
