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 5AF6610CBC for ; Tue, 12 Nov 2013 16:57:02 +0000 (UTC) Received: (qmail 46033 invoked by uid 500); 12 Nov 2013 16:56:59 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 45852 invoked by uid 500); 12 Nov 2013 16:56:59 -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 45839 invoked by uid 99); 12 Nov 2013 16:56:58 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Nov 2013 16:56:58 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of tyler@datastax.com designates 209.85.215.54 as permitted sender) Received: from [209.85.215.54] (HELO mail-la0-f54.google.com) (209.85.215.54) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Nov 2013 16:56:51 +0000 Received: by mail-la0-f54.google.com with SMTP id ev20so1846057lab.41 for ; Tue, 12 Nov 2013 08:56:31 -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:from:date :message-id:subject:to:content-type; bh=b47SUSIxvKMj7Plt4UCudcJf0TkgfHQGmL7rElL4KKA=; b=f/7HoWcie7FG1nslQJ8+lH71mZ3LRgXdf0EjA1k3nGC62dNlWswYJIYbe9jxAdK9tn kKdjJnHm4n1epIs1QRgC3ThRYDjIv1XTFdOHl87gjiaef11btuVhCJAEEAY6b5uPDOsR 6HFkdz+dDF779HGySAzJtGPNfFHTjnioOLhFqltKdMBexyJg5OQ3/2mgfV3rNBKzWw5w bJyonAr3frSVAjnOsKRisZn6ubX9m802pAFgOXH/e81z7DL8/ec2mCziEoYkmdOiXFVj CLz8i4nC+uLXGGBhIHHY+IuHpeMKuEDMp6lYr5ebyivNleB6D2/2xI7ejxxapbROCGEf 0wrg== X-Gm-Message-State: ALoCoQlCBOkTTtT+PZO55etDKoG+/5E5QboI73O8vMQUmcO7IzJXEFulK6hFZJsM8HdokUoNCkPj X-Received: by 10.152.120.102 with SMTP id lb6mr2232412lab.37.1384275390938; Tue, 12 Nov 2013 08:56:30 -0800 (PST) MIME-Version: 1.0 Received: by 10.112.141.194 with HTTP; Tue, 12 Nov 2013 08:56:10 -0800 (PST) In-Reply-To: References: From: Tyler Hobbs Date: Tue, 12 Nov 2013 10:56:10 -0600 Message-ID: Subject: Re: CF backup / restore selected columns To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=089e01227ab6f2d39104eafdba52 X-Virus-Checked: Checked by ClamAV on apache.org --089e01227ab6f2d39104eafdba52 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable There's no easy way to do this that I'm aware of. Snapshots are just hardlinks to existing SSTable files. Your best option is probably either scanning the CF with a normal client or setting up an M/R job. On Mon, Nov 11, 2013 at 5:06 PM, Turi, Ferenc (GE Power & Water, Non-GE) < Ferenc.Turi@ge.com> wrote: > Hi, > > > > I have a question which I was not able to find the right answer for. > > What is the best way to backup/restore a set of columns? > > Let=92s say we have: > > > > CF1(a,b,c,d) =96 a,b,c,d are columns/ original CF we would like to take > backup from > > > > CF2(d,e,f,g) =96 e,f,g are different columns, we would restore data into = CF2 > > > > A,b,c,d,e,f,g have the same type. Let=92s say text. > > > > Cassandra version: 1.2.10, 3.1.4 datastax distribution > > The structure which we would like to take backup from differs from the > restore CF. > > > > - Copy from/copy to cannot be used in cqlsh / error: rcp_timeout > > - Hive /insert overwrite xxx from =85. cannot specify columns / = I > don=92t want to save all columns and would like to restore into different > structure. > > > > So what would be the solution? Is it possible at all? > > > > Thanks. > > > --=20 Tyler Hobbs DataStax --089e01227ab6f2d39104eafdba52 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable
There's no easy way to do this that I'm aware of.= =A0 Snapshots are just hardlinks to existing SSTable files.=A0 Your best op= tion is probably either scanning the CF with a normal client or setting up = an M/R job.


On Mon,= Nov 11, 2013 at 5:06 PM, Turi, Ferenc (GE Power & Water, Non-GE) <Fe= renc.Turi@ge.com> wrote:

Hi,

=A0

I have a question which I was not able to find the r= ight answer for.

What is the best way to backup/restore a set of colu= mns?

Let=92s say we have:

=A0

CF1(a,b,c,d) =96 a,b,c,d are columns/ original CF we= would like to take backup from

=A0

CF2(d,e,f,g) =96 e,f,g are different columns, we wou= ld restore data into CF2

=A0

A,b,c,d,e,f,g have the same type. Let=92s say text.<= u>

=A0

Cassandra version: 1.2.10, 3.1.4 datastax distributi= on

The structure which we would like to take backup fro= m differs from the restore CF.

=A0

-=A0= =A0=A0=A0=A0=A0=A0=A0=A0 Copy from/copy to cannot be used in cqlsh / error: rcp= _timeout

-=A0= =A0=A0=A0=A0=A0=A0=A0=A0 Hive /insert overwrite xxx from =85. cannot specify co= lumns / I don=92t want to save all columns and would like to restore into d= ifferent structure.

=A0

So what would be the solution? Is it possible at all= ?

=A0

Thanks.

=A0




--
Tyler Hobbs
DataStax
--089e01227ab6f2d39104eafdba52--