incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Powis <stephen.po...@pardot.com>
Subject Re: Help deleting data using cql v3
Date Fri, 25 May 2012 04:42:59 GMT
Thanks for the info Roland!  I guess I missed that bug report in my google
searching.

Stephen

On Fri, May 25, 2012 at 12:26 AM, Roland Mechler <rmechler@sencha.com>wrote:

> 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