Hi Dojo,
I'm trying to recreate my Cassandra table schema on another server by following the steps mentioned in another post: Cassandra - Restore backup : How to recreate the table schema?
Problem is that I get an unknown property exception:
Below an example of one of the tables that I need to add containing this property
CREATE TABLE "SLDMADB".analytics_alarmfocus (
di int,
ei int,
pi int,
i text,
dn text,
fd text,
PRIMARY KEY (( di, ei ), pi, i)
) WITH CLUSTERING ORDER BY ( pi ASC, i ASC )
AND bloom_filter_fp_chance = 0.01
AND comment = ''
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 864000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99.0PERCENTILE'
AND caching = {
'keys' : 'ALL',
'rows_per_partition' : 'NONE'
}
AND compression = {
'chunk_length_in_kb' : 64,
'class' : 'LZ4Compressor',
'enabled' : true
}
AND compaction = {
'class' : 'SizeTieredCompactionStrategy',
'max_threshold' : 32,
'min_threshold' : 4
};
What can I do to make this work?
Not 100% cartain but I think there might be incompatibilities in Schemas between 3.x (where your export was done) and 4.x
The error might be due to the fact that some table properties are no longer supported or at least I cant find this specific property in Cassandra 4.x
Table properties 3.x: https://docs.datastax.com/en/cqloss/3.x/cql/cql_reference/cqlCreateTable.html#table_optionshttps://docs.datastax.com/en/cql-oss/3.1/cql/cql_reference/tabProp.html
Table properties 4.x : https://cassandra.apache.org/doc/latest/cassandra/cql/ddl.html (I cant find 'dclocal_read_repair_chance ' property here)
....but maybe there is a way to override it.
Hi Wale,
Downgrading my Cassandra to version 3.11 did the trick. Thank you!