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.
