a.zipkin-storage-cassandra.2.7.3.source-code.cassandra-schema-cql3-upgrade-1.txt Maven / Gradle / Ivy
// upgrade cql to add the default_time_to_live option on each table
ALTER TABLE zipkin.service_span_name_index
WITH compaction = {'class': 'org.apache.cassandra.db.compaction.DateTieredCompactionStrategy', 'max_window_size_seconds': '86400'}
AND default_time_to_live = 259200;
ALTER TABLE zipkin.service_name_index
WITH compaction = {'class': 'org.apache.cassandra.db.compaction.DateTieredCompactionStrategy', 'max_window_size_seconds': '86400'}
AND default_time_to_live = 259200;
ALTER TABLE zipkin.span_names
WITH compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', 'unchecked_tombstone_compaction': 'true', 'tombstone_threshold': '0.2'}
AND default_time_to_live = 259200;
ALTER TABLE zipkin.annotations_index
WITH compaction = {'class': 'org.apache.cassandra.db.compaction.DateTieredCompactionStrategy', 'max_window_size_seconds': '86400'}
AND default_time_to_live = 259200;
ALTER TABLE zipkin.dependencies
WITH compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', 'unchecked_tombstone_compaction': 'true', 'tombstone_threshold': '0.2'}
AND default_time_to_live = 259200;
ALTER TABLE zipkin.service_names
WITH compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', 'unchecked_tombstone_compaction': 'true', 'tombstone_threshold': '0.2'}
AND default_time_to_live = 259200;
ALTER TABLE zipkin.traces
WITH compaction = {'class': 'org.apache.cassandra.db.compaction.DateTieredCompactionStrategy', 'max_window_size_seconds': '86400'}
AND default_time_to_live = 604800;