incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tyler Hobbs <ty...@datastax.com>
Subject Re: CF backup / restore selected columns
Date Tue, 12 Nov 2013 16:56:10 GMT
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’s say we have:
>
>
>
> CF1(a,b,c,d) – a,b,c,d are columns/ original CF we would like to take
> backup from
>
>
>
> CF2(d,e,f,g) – e,f,g are different columns, we would restore data into CF2
>
>
>
> A,b,c,d,e,f,g have the same type. Let’s 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 …. cannot specify columns / I
> don’t 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.
>
>
>



-- 
Tyler Hobbs
DataStax <http://datastax.com/>

Mime
View raw message