Ok, i tried a simple test and get an error. Here the steps:
In cassandra (5.0.4) container:
1: Create Keyspace
CREATE KEYSPACE IF NOT EXISTS edm WITH REPLICATION = {'class' : 'SimpleStrategy', 'replication_factor' : 1};
2: Create Table
CREATE TABLE IF NOT EXISTS edm.Zeitreihe(
Id int,
Datum timestamp,
Wert decimal,
Status int,
PRIMARY KEY (Id, Datum)
);
3: Insert some Data
INSERT INTO edm.zeitreihe(Id, Datum, Wert, Status) VALUES (1, '2025-02-01', 8.45, 3);
INSERT INTO edm.zeitreihe(Id, Datum, Wert, Status) VALUES (2, '2025-02-01', 1.45, 2);
INSERT INTO edm.zeitreihe(Id, Datum, Wert, Status) VALUES (3, '2025-02-01', 2.45, 4);
INSERT INTO edm.zeitreihe(Id, Datum, Wert, Status) VALUES (4, '2025-02-01', 3.45, 9);
INSERT INTO edm.zeitreihe(Id, Datum, Wert, Status) VALUES (5, '2025-02-01', 4.45, 2);
4: Create snapshot
nodetool stop compaction
nodetool snapshot edm -t foobar
5: Stoping cassandra container and starting scylladb (2025.1.2) container
6: Reexecute steps 1 and 2 inside ScyllaDB
7: Copy the following files from cassandra/data/edm/zeitreihe-uuid/snapshots/foobar/ to scylla/data/edm/zeitreihe-uuid/upload
nb-1-big-CompressionInfo.db
nb-1-big-Data.db
nb-1-big-Filter.db
nb-1-big-Index.db
nb-1-big-Statistics.db
nb-1-big-Summary.db
8: Import data via nodetool
nodetool refresh edm zeitreihe --load-and-stream
… returns the following error:
error executing POST request to http://localhost:10000/storage_service/sstables/edm with parameters {"load_and_stream": "true", "cf": "zeitreihe"}: remote replied with status code 500 Internal Server Error:
Failed to load new sstables: sstables::malformed_sstable_exception (invalid version for file nb-1-big-Summary.db. Name doesn't match any known version.)
I get the same error if I copy only the file nb-1-big-Data.db into the upload-Folder.
I hope this helps to identify the problem or my misunderstanding.
Many thanks in advance!
daprodigy