cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roland Mechler <rmech...@sencha.com>
Subject Re: Help deleting data using cql v3
Date Fri, 25 May 2012 04:26:30 GMT
This is a known issue, see
https://issues.apache.org/jira/browse/CASSANDRA-4193.

In the meantime, a workaround is to specify all the column names to be
deleted. I.e.,

  delete my_value from testCol where my_id='1_71548' and
time_id=2fc39fa0-1dd5-11b2-9b6a-395f35722afe;

should work.

(I had the same question answered here
http://www.datastax.com/dev/blog/whats-new-in-cql-3-0)

-Roland

On Thu, May 24, 2012 at 6:24 PM, Stephen Powis <stephen.powis@pardot.com>wrote:

> I have the following schema setup in cassandra 1.1 with cql 3:
>
> CREATE TABLE testCol (
>   my_id varchar,
>   time_id TimeUUIDType,
>   my_value int,
>   PRIMARY KEY (my_id, time_id)
> );
>
> and the following data already inserted:
>
> my_id        | time_id                                               |
> my_value |
> 1_71548     | 2fc39fa0-1dd5-11b2-9b6a-395f35722afe |          1    |
>
> but when I issue the following delete command using cqlsh -3, the data is
> not removed.
>
> delete from testCol where my_id='1_71548' and
> time_id=2fc39fa0-1dd5-11b2-9b6a-395f35722afe;
>
> Is it possible to remove data using the full composite key?  Or am I
> formatting the UUID incorrectly?
>
> Thanks!
> Stephen
>

Mime
View raw message