Re: Deleting column names

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 > wrote: From my understanding, this wo

Re: Deleting column names

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 wrote: > 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: >

Re: Deleting column names

>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 abo

Re: Deleting column names

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

Re: Deleting column names

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 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, Andrea

Re: Deleting column names

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? > > Than

Re: Deleting column names

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 up

Re: Deleting column names

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