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/> >> >> >> >