search

scylladb / scylla-tools-java

Apache Cassandra, supplying tools for Scylla
Apache License 2.0
53 stars 85 forks source link

unable to load sstables with sstableloader when primarykey composition has changed. #388

Closed nopzdk closed 7 months ago

nopzdk commented 7 months ago

we are trying to migrate data with sstableloader original table is like CREATE TABLE keyspace1.table1 ( key text, value text, bucket int PRIMARY KEY (key, bucket)

destination table is CREATE TABLE keyspace1.table1 ( key text, value text, bucket int PRIMARY KEY ((key, bucket))

because of this i cannot upload data to node, we should change it to load schema from source instead of destination table.

denesb commented 7 months ago

Such migrations are not supported, with any migration methods. You have to rewrite your table, with a user-written application, there is no way to do this automatically.