incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wang liang <wla...@gmail.com>
Subject Re: DELETE query failing in CQL 3.0
Date Mon, 22 Oct 2012 05:31:21 GMT
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 <aaron@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.Ryabin@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.

Mime
View raw message