Originally from the User Slack
@Daria_Fedorova: Hi
I am planning to migrate some data between TWC tables (to change TTL of this data) and I am afraid my data will become commingled.
The doc https://opensource.docs.scylladb.com/stable/kb/compaction.html seems to say that there is no way to have a table available for real time write during migration of historical data ?
The plan was
1 full scan and filter needed data from old table and write it to the new table with TTL=new_table_ttl - record_age (moved data up to timeuuid T0)
2 start writing in new table from timeuuid T1
3 migrate historical data missed from T0 to T1
But third step would involve writing old and new data at the same time. And this is not allowed ?
Compaction | ScyllaDB Docs
@avi: If you use the USING TIMESTAMP option to write historical data, it will get sorted into the right buckets. Best is to use the original timestamps.