All Downloads are FREE. Search and download functionalities are using the official Maven repository.

a.zipkin-storage-cassandra.2.8.2.source-code.cassandra-schema-cql3-upgrade-1.txt Maven / Gradle / Ivy

There is a newer version: 2.8.4
Show newest version

// 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;




© 2015 - 2024 Weber Informatics LLC | Privacy Policy