Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 24049 invoked from network); 15 Dec 2010 22:53:24 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 15 Dec 2010 22:53:24 -0000 Received: (qmail 83898 invoked by uid 500); 15 Dec 2010 22:53:23 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 83799 invoked by uid 500); 15 Dec 2010 22:53:23 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 83791 invoked by uid 99); 15 Dec 2010 22:53:23 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Dec 2010 22:53:23 +0000 X-ASF-Spam-Status: No, hits=2.9 required=10.0 tests=HTML_MESSAGE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [209.85.210.172] (HELO mail-iy0-f172.google.com) (209.85.210.172) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Dec 2010 22:53:16 +0000 Received: by iyi42 with SMTP id 42so1260486iyi.31 for ; Wed, 15 Dec 2010 14:52:55 -0800 (PST) MIME-Version: 1.0 Received: by 10.231.17.4 with SMTP id q4mr4329281iba.13.1292453575337; Wed, 15 Dec 2010 14:52:55 -0800 (PST) Received: by 10.231.144.75 with HTTP; Wed, 15 Dec 2010 14:52:55 -0800 (PST) X-Originating-IP: [64.132.24.248] In-Reply-To: References: Date: Wed, 15 Dec 2010 16:52:55 -0600 Message-ID: Subject: Re: batch mutate with only deletions on 0.7beta2 From: Tyler Hobbs To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=000325574d823f27e704977accaf --000325574d823f27e704977accaf Content-Type: text/plain; charset=ISO-8859-1 There's no problem doing deletions with batch_mutate, but you are probably seeing this: http://wiki.apache.org/cassandra/FAQ#range_ghosts - Tyler On Wed, Dec 15, 2010 at 4:26 PM, Nick Santini wrote: > since the 0.7beta2 version doesnt support indexes for Super CF or for > columns that you might not now the name yet, im supporting them manually by > adding a row on the same CF where the key is the name of the column plus the > value, and in the columns hold the key to the referenced rows > > this works as in i can actually find my rows using the secondary index rows > > but when i try to delete the original row i want to update my secondary > indexs, so i create a mutation map in the same way i did it when i saved my > information, but this time it only contains deletions for those secondary > indexs rows and only for the column referencing to the row being deleted. > but this doesnt seem to work, it comes back successfully (no erros), but im > still able to find the references to the deleted row in those secondary > indexes > > is there any issue trying to run a batch_mutate with only deletions? > > thanks > > Nicolas Santini > > --000325574d823f27e704977accaf Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable There's no problem doing deletions with batch_mutate, but you are proba= bly seeing this:

http://wiki.apache.org/cassandra/FAQ#range_ghosts

- T= yler

On Wed, Dec 15, 2010 at 4:26 PM, Nick Santin= i <nick.san= tini@kaseya.com> wrote:

since the 0.7beta2 version doesnt support indexes for Super CF or for = columns that you might not now the name yet, im supporting them manually by= adding a row on the same CF where the key is the name of the column plus t= he value, and in the columns hold the key to the referenced rows

this works as in i can actually find my rows using the = secondary index rows

but when i try to delete the = original row i want to update my secondary indexs, so i create a mutation m= ap in the same way i did it when i saved my information, but this time it o= nly contains deletions for those secondary indexs rows and only for the col= umn referencing to the row being deleted.

but this doesnt seem to work, it comes back=A0successfully (no erros),= but im still able to find the references to the deleted row in those secon= dary indexes

is there any issue trying to run a ba= tch_mutate with only deletions?

thanks=A0

Nicolas Santini

--000325574d823f27e704977accaf--