Is there a reason you can't use:

DELETE FROM table_name WHERE s = ? AND p = ? AND o = ? AND c = ?;


On Mon, Apr 21, 2014 at 6:51 PM, Eric Plowe <eric.pl...@gmail.com> wrote:

> Also I don't think you can null out columns that are part of the primary
> key after they've been set.
>
>
> On Monday, April 21, 2014, Andreas Wagner <
> andreas.josef.wag...@googlemail.com> wrote:
>
>> Hi cassandra users, hi Sebastian,
>>
>> I'd be interested in this ... is there any update/solution?
>>
>> Thanks so much ;)
>> Andreas
>>
>> On 04/16/2014 11:43 AM, Sebastian Schmidt wrote:
>>
>>> Hi,
>>>
>>> I'm using a Cassandra table to store some data. I created the table like
>>> this:
>>> CREATE TABLE IF NOT EXISTS table_name (s BLOB, p BLOB, o BLOB, c BLOB,
>>> PRIMARY KEY (s, p, o, c));
>>>
>>> I need the at least the p column to be sorted, so that I can use it in a
>>> WHERE clause. So as far as I understand, the s column is now the row
>>> key, and (p, o, c) is the column name.
>>>
>>> I tried to delete single entries with a prepared statement like this:
>>> DELETE p, o, c FROM table_name WHERE s = ? AND p = ? AND o = ? AND c = ?;
>>>
>>> That didn't work, because p is a primary key part. It failed during
>>> preparation.
>>>
>>> I also tried to use variables like this:
>>> DELETE ?, ?, ? FROM table_name WHERE s = ?;
>>>
>>> This also failed during preparation, because ? is an unknown identifier.
>>>
>>>
>>> Since I have multiple different p, o, c combinations per s, deleting the
>>> whole row identified by s is no option. So how can I delete a s, p, o, c
>>> tuple, without deleting other s, p, o, c tuples with the same s? I know
>>> that this worked with Thrift/Hector before.
>>>
>>> Regards,
>>> Sebastian
>>>
>>
>>


-- 
Steve Robenalt
Software Architect
HighWire | Stanford University
425 Broadway St, Redwood City, CA 94063

srobe...@stanford.edu
http://highwire.stanford.edu

Reply via email to