Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 00DA710429 for ; Tue, 25 Feb 2014 17:17:58 +0000 (UTC) Received: (qmail 26339 invoked by uid 500); 25 Feb 2014 17:17:54 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 26313 invoked by uid 500); 25 Feb 2014 17:17:54 -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 26305 invoked by uid 99); 25 Feb 2014 17:17:54 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 25 Feb 2014 17:17:54 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=HTML_IMAGE_ONLY_20,HTML_MESSAGE,HTML_SHORT_LINK_IMG_3,RCVD_IN_DNSWL_LOW,SPF_PASS,T_REMOTE_IMAGE X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jlacefield@datastax.com designates 209.85.128.177 as permitted sender) Received: from [209.85.128.177] (HELO mail-ve0-f177.google.com) (209.85.128.177) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 25 Feb 2014 17:17:48 +0000 Received: by mail-ve0-f177.google.com with SMTP id db12so766409veb.8 for ; Tue, 25 Feb 2014 09:17:27 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=4Zn+A5CFRyFhID3f3JN107jkfzAQ+0cG+j8DnvgzggQ=; b=LEwHtmdXjl+d6OKsq+xWuhFBFpeZ7CXmI63oeruIjcf7yNqUX1Cc7khCie3Qom42p4 5PgMZGfLYiR7VmRFr4ec32q8kyzbGsZLpL7gpOXUK3/2zcRD7+IhMXimpb3K/+9ocwWZ MqedxzXwfdsV5vSLlhC8/W2keOFyKwe1IXIUtyEjyhfpOb6MOGSLMIIhcyIkBbRQVNn1 fKiPnuUTItl1kI12GPHppGk2XnOmWo7b2n2GB0kBR6Jd0IRk6LasWugfIQMYHRHa1ZIP jMfC6iiuEOrAFbKmYMAMvFSIrJyMzfBAR0kbMKP1e4kd1yxCjW3XcGAocQ1pK+angPOB +LBw== X-Gm-Message-State: ALoCoQlR9OIFLxoRDkUlaIxVNaznnyal4ZCPG5SF+TCBVxr8vqs4XB9bxpwRoZXiT3DkUOg90pC4 MIME-Version: 1.0 X-Received: by 10.58.161.227 with SMTP id xv3mr1650737veb.31.1393348647500; Tue, 25 Feb 2014 09:17:27 -0800 (PST) Received: by 10.53.4.3 with HTTP; Tue, 25 Feb 2014 09:17:27 -0800 (PST) In-Reply-To: <8BE26E0070208642993B19C304569FA0018E7E7D@MOKSCY3MSGUSR9A.ITServices.sbc.com> References: <8BE26E0070208642993B19C304569FA0018E7E7D@MOKSCY3MSGUSR9A.ITServices.sbc.com> Date: Tue, 25 Feb 2014 12:17:27 -0500 Message-ID: Subject: Re: Reverse a delete operation From: Jonathan Lacefield To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=047d7b6da9b22ed21804f33e43e3 X-Virus-Checked: Checked by ClamAV on apache.org --047d7b6da9b22ed21804f33e43e3 Content-Type: text/plain; charset=ISO-8859-1 A couple of options: 1) Do you have a snapshot? If so, you could recover form the snapshot? 2) Look in the stable via SSTable2JSON and find the pre-deleted row state then reinsert it. There are probably other options as well. Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 On Tue, Feb 25, 2014 at 12:13 PM, PARASHAR, BHASKARJYA JAY wrote: > We deleted a row by mistake. Is there a way to somehow recover it? > > > > Thanks > --047d7b6da9b22ed21804f33e43e3 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
A couple of options:

=A0 1) Do you have= a snapshot? =A0If so, you could recover form the snapshot? =A0
= =A0 2) Look in the stable via SSTable2JSON and find the pre-deleted row sta= te then reinsert it.

There are probably other options as well.

Jonathan L= acefield
Solutions Architect, DataStax
(404) 822 3487






On Tue, Feb 25, 2014 at 12:13 PM, PARASH= AR, BHASKARJYA JAY <bp134r@att.com> wrote:

We deleted a row by mista= ke. Is there a way to somehow recover it?

=A0<= /p>

Thanks


--047d7b6da9b22ed21804f33e43e3--