Bulkload into a different CF

[Oleg Proudnikov <ol...@cloudorange.com>]

Hello,

Is it possible to create an exact replica of a CF by these steps?

1. Take a snapshot
2. Isolate sstables for CF1
3. Rename sstables into CF2
4. Bulk load renamed sstables into newly created CF2 within the same Keyspace

Or would you suggest using sstable2json instead?

Thank you very much,
Oleg

Re: Bulkload into a different CF

[Benoit Perroud <be...@noisette.ch>]

I would just try to copy instead of moving first, and dropping the old
CF or the not needed snapshot if necessary when everything is ok.


2012/5/1 Oleg Proudnikov <ol...@cloudorange.com>:
> Benoit Perroud <benoit <at> noisette.ch> writes:
>
>>
>> You can copy the sstables (renaming them accordingly) and
>> call nodetool refresh.
>>
>
> Thank you, Benoit.
>
> In that case could I try snapshot+move&rename+refresh on a live system?
>
> Regards,
> Oleg
>
>



-- 
sent from my Nokia 3210

Re: Bulkload into a different CF

[Oleg Proudnikov <ol...@cloudorange.com>]

Benoit Perroud <benoit <at> noisette.ch> writes:

> 
> You can copy the sstables (renaming them accordingly) and 
> call nodetool refresh.
> 

Thank you, Benoit.

In that case could I try snapshot+move&rename+refresh on a live system?

Regards,
Oleg

Re: Bulkload into a different CF

[Benoit Perroud <be...@noisette.ch>]

!! Without any guarantee. I know it works but I never used this in production !!

You can copy the sstables (renaming them accordingly) and call nodetool refresh.

Don't forget to create your column family CF2 before.


2012/5/1 Oleg Proudnikov <ol...@cloudorange.com>:
> Hello,
>
> Is it possible to create an exact replica of a CF by these steps?
>
> 1. Take a snapshot
> 2. Isolate sstables for CF1
> 3. Rename sstables into CF2
> 4. Bulk load renamed sstables into newly created CF2 within the same Keyspace
>
> Or would you suggest using sstable2json instead?
>
> Thank you very much,
> Oleg
>



-- 
sent from my Nokia 3210