[jira] [Created] (CASSANDRA-6292) CQL should be able to do a delete with a > or < operator on a clustering portion of a primary key

["Tupshin Harper (JIRA)" <ji...@apache.org>]

Tupshin Harper created CASSANDRA-6292:
-----------------------------------------

             Summary: 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)