IMHO The best step by step description of what you need to do is here https://issues.apache.org/jira/browse/CASSANDRA-1585?focusedCommentId=13488959&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-13488959
The only difference is that you need to copy data from one table only. I did it for a whole keyspace. On Sun, Apr 8, 2018 at 3:06 PM Jean Carlo <jean.jeancar...@gmail.com> wrote: > You can use the same procedure to restore a table from snapshot from > datastax webpage > > > https://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_backup_snapshot_restore_t.html > > 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 > course > > > Saludos > > 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 <saprykin.dmi...@gmail.com > > wrote: > >> 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 <nitankai...@gmail.com> >> 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 <onmstes...@zoho.com> >>> 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 <https://www.zoho.com/mail/> >>> >>> >>> >> >
