Re: DELETE query failing in CQL 3.0

2012-10-22 Thread Tyler Hobbs
ay, 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

RE: DELETE query failing in CQL 3.0

2012-10-22 Thread Ryabin, Thomas
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 thi

Re: DELETE query failing in CQL 3.0

2012-10-21 Thread wang liang
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

Re: DELETE query failing in CQL 3.0

2012-10-21 Thread aaron morton
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" wrote: > I have a column family called “books”, and am trying to delete all rows where > the “title” column is

DELETE query failing in CQL 3.0

2012-10-19 Thread Ryabin, Thomas
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