Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of eric.plowe@gmail.com designates
 209.85.219.46 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <5355B35B.7070507@googlemail.com>
References: <534E50A4.9030805@gmail.com>
	<5355B35B.7070507@googlemail.com>
Date: Mon, 21 Apr 2014 21:50:04 -0400
Message-ID: 
 <CALKyeu-W58KzLjF_i+GF6Xa-Z-wz4syObT0o=XB6sSkpcY0b3Q@mail.gmail.com>
Subject: Re: Deleting column names
From: Eric Plowe <eric.plowe@gmail.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=001a11c2903cbae8c604f797d5a7

--001a11c2903cbae8c604f797d5a7
Content-Type: text/plain; charset=UTF-8

Setting the columns to null is essentially deleting them from my
understanding. A delete operation works on the entire row.

On Monday, April 21, 2014, Andreas Wagner <
andreas.josef.wagner@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
>>
>
>

--001a11c2903cbae8c604f797d5a7
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Setting the columns to null is essentially deleting them from my understand=
ing. A delete operation works on the entire row.<span></span><br><br>On Mon=
day, April 21, 2014, Andreas Wagner &lt;<a href=3D"mailto:andreas.josef.wag=
ner@googlemail.com">andreas.josef.wagner@googlemail.com</a>&gt; wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">Hi cassandra users, hi Sebastian,<br>
<br>
I&#39;d be interested in this ... is there any update/solution?<br>
<br>
Thanks so much ;)<br>
Andreas<br>
<br>
On 04/16/2014 11:43 AM, Sebastian Schmidt wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
Hi,<br>
<br>
I&#39;m using a Cassandra table to store some data. I created the table lik=
e<br>
this:<br>
CREATE TABLE IF NOT EXISTS table_name (s BLOB, p BLOB, o BLOB, c BLOB,<br>
PRIMARY KEY (s, p, o, c));<br>
<br>
I need the at least the p column to be sorted, so that I can use it in a<br=
>
WHERE clause. So as far as I understand, the s column is now the row<br>
key, and (p, o, c) is the column name.<br>
<br>
I tried to delete single entries with a prepared statement like this:<br>
DELETE p, o, c FROM table_name WHERE s =3D ? AND p =3D ? AND o =3D ? AND c =
=3D ?;<br>
<br>
That didn&#39;t work, because p is a primary key part. It failed during<br>
preparation.<br>
<br>
I also tried to use variables like this:<br>
DELETE ?, ?, ? FROM table_name WHERE s =3D ?;<br>
<br>
This also failed during preparation, because ? is an unknown identifier.<br=
>
<br>
<br>
Since I have multiple different p, o, c combinations per s, deleting the<br=
>
whole row identified by s is no option. So how can I delete a s, p, o, c<br=
>
tuple, without deleting other s, p, o, c tuples with the same s? I know<br>
that this worked with Thrift/Hector before.<br>
<br>
Regards,<br>
Sebastian<br>
</blockquote>
<br>
</blockquote>

--001a11c2903cbae8c604f797d5a7--