Thanks :) This works ...
Kind regards
Andreas
On 04/22/2014 06:05 PM, Laing, Michael wrote:
Your understanding is incorrect - the easiest way to see that is to
try it.
On Tue, Apr 22, 2014 at 12:00 PM, Sebastian Schmidt isib...@gmail.com
mailto:isib...@gmail.com wrote:
From my
Referring to the original post, I think the confusion is what is a row in
this context:
So as far as I understand, the s column is now the *row *key
...
Since I have multiple different p, o, c combinations per s, deleting the whole
*row* identified by s is no option
The s column is in fact
From my understanding, this would delete all entries with the given s.
Meaning, if I have inserted (sa, p1, o1, c1) and (sa, p2, o2, c2),
executing this:
DELETE FROM table_name WHERE s = sa AND p = p1 AND o = o1 AND c = c1
would delete sa, p1, o1, c1, p2, o2, c2. Is this correct? Or does the
Your understanding is incorrect - the easiest way to see that is to try it.
On Tue, Apr 22, 2014 at 12:00 PM, Sebastian Schmidt isib...@gmail.comwrote:
From my understanding, this would delete all entries with the given s.
Meaning, if I have inserted (sa, p1, o1, c1) and (sa, p2, o2, c2),
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
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.wag...@googlemail.com wrote:
Hi cassandra users, hi Sebastian,
I'd be interested in this ... is there any
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
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
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,