Hi. I am trying to restore from a 3 node cluster to 2 node /one node cluster. I have taken the snapshot of the 3 node cluster ( its has 3 tables).
The snapshot is in a directory called cassandra/data/keyspace1/table1, cassandra/data/keyspace1/table2.. and similarly one more .
I am using sstableloader to restore them ( i can only use that) . Can i restore that entire keyspace to my target cluster? Or should i do it table by table? What is the command for either of the above options?
Will restoring via sstableloader overwrite some of the existing tables if present in the keyspace or skip them?