Update a Primary Key

Topic: Can you Update a Primary Key in Scylla?

Audience: Scylla administrators

In Scylla, you cannot update a primary key. It is impossible to do so.

However, you can migrate the data from the old table with the old primary key to a new table with a new primary key. There are two ways to handle the migration:

  • Fork-lifting the historical data with the Spark Migrator tool.

  • Double writing the new data.

If you are running Scylla Enterprise it is advantageous to control the migration resources using Workload Prioritization.