Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of
 andreas.josef.wagner@googlemail.com designates 74.125.83.45 as permitted
 sender)
Message-ID: <5355B35B.7070507@googlemail.com>
Date: Tue, 22 Apr 2014 02:10:03 +0200
From: Andreas Wagner <andreas.josef.wagner@googlemail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.4.0
MIME-Version: 1.0
To: user@cassandra.apache.org
Subject: Re: Deleting column names
References: <534E50A4.9030805@gmail.com>
In-Reply-To: <534E50A4.9030805@gmail.com>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

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