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
*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
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
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
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