how do I restore a previous backed up snapshot If I alter a table by adding new column or change the partition key of the table
Restoring an old schema
The snapshot itself contains a copy of the schema in a file called schema.cql.
When you want to restore a table with a different schema, you will need to:
DROPthe table.- Recreate the schema using
schema.cqlfile. - Restore the SSTables from the snapshot.
NOTE: You will lose the data created after the snapshot was taken.
New partition key
It is not possible to change the partition key of a table once it's been created.
If you need a new partition key, you will need to start from scratch and create a new table.
If you want to import the data in old table, you will need an ETL tool (like a Spark job) or write an app that will migrate the data to the new table. Cheers!
6 People are following this question.
