cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean Carlo <>
Subject Re: copy from one table to another
Date Sun, 08 Apr 2018 19:06:14 GMT
You can use the same procedure to restore a table from snapshot from
datastax webpage

Just two modifications.

after step 5, modify the name of the sstables to add the name of the table
you want to copy to.

and in the step 6 copy the sstables to the right directory corresponding to
the tale you want to copy to.

Be sure you have an snapshot of the table source and ignore step 4 of


Jean Carlo

"The best way to predict the future is to invent it" Alan Kay

On Sun, Apr 8, 2018 at 6:33 PM, Dmitry Saprykin <>

> You can copy hardlinks to ALL SSTables from old to new table and then
> delete part of data you do not need in a new one.
> On Sun, Apr 8, 2018 at 10:20 AM, Nitan Kainth <>
> wrote:
>> If it for testing and you don’t need any specific data, just copy a set
>> of sstables with all files of that sequence and move to target tables
>> directory and rename it.
>> Restart target node or run nodetool refresh
>> Sent from my iPhone
>> On Apr 8, 2018, at 4:15 AM, onmstester onmstester <>
>> wrote:
>> Is there any way to copy some part of a table to another table in
>> cassandra? A large amount of data should be copied so i don't want to fetch
>> data to client and stream it back to cassandra using cql.
>> Sent using Zoho Mail <>

View raw message