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.po...@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 >
