For what it's worth, Cassandra 1.2 will support deleting a slice of columns, allowing you to specify the first N components of the primary key in a WHERE clause for a DELETE statement: https://issues.apache.org/jira/browse/CASSANDRA-3708
On Mon, Oct 22, 2012 at 8:45 AM, Ryabin, Thomas <thomas.rya...@mckesson.com>wrote: > I figured out the problem. The DELETE query only works if the column > used in the WHERE clause is also the first column used to define the > PRIMARY KEY.**** > > ** ** > > -Thomas**** > > ** ** > > *From:* wang liang [mailto:wla...@gmail.com] > *Sent:* Monday, October 22, 2012 1:31 AM > *To:* user@cassandra.apache.org > *Subject:* Re: DELETE query failing in CQL 3.0**** > > ** ** > > It is better to provide table definition. I guess the reason is below > statement. **** > > " a table must define at least one column that is not part of the PRIMARY > KEY as a row exists in Cassandra only if it contains at least one value for > one such column "**** > > Please check this document > here<http://cassandra.apache.org/doc/cql3/CQL.html#createKeyspaceStmt> > . **** > > ** ** > > On Mon, Oct 22, 2012 at 7:53 AM, aaron morton <aa...@thelastpickle.com> > wrote:**** > > Can you paste the table definition ? **** > > ** ** > > Thanks**** > > ** ** > > -----------------**** > > Aaron Morton**** > > Freelance Developer**** > > @aaronmorton**** > > http://www.thelastpickle.com**** > > ** ** > > On 20/10/2012, at 5:53 AM, "Ryabin, Thomas" <thomas.rya...@mckesson.com> > wrote:**** > > > > **** > > I have a column family called “books”, and am trying to delete all rows > where the “title” column is equal to “hatchet”. This is the query I am > using:**** > > DELETE FROM books WHERE title = ‘hatchet’;**** > > **** > > This query is failing with this error:**** > > Bad Request: PRIMARY KEY part title found in SET part**** > > **** > > I am using Cassandra 1.1 and CQL 3.0. What could be the problem?**** > > **** > > -Thomas**** > > ** ** > > > > **** > > ** ** > > -- > Best wishes, > Helping others is to help myself.**** > -- Tyler Hobbs DataStax <http://datastax.com/>
