RE: DELETE query failing in CQL 3.0

2012-10-22 Thread Ryabin, Thomas
/www.thelastpickle.com On 20/10/2012, at 5:53 AM, "Ryabin, Thomas" mailto: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

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

How to add secondary index to existing column family with CLI?

2012-08-20 Thread Ryabin, Thomas
I want to add a secondary index to an existing column family, but am running into some trouble. I'm trying to use the Cassandra CLI to add the secondary index. The column family is called "books", the column I'm trying to index is called "title", the key validation class is UTF8Type, and the def