Page MenuHomePhabricator
Paste P6318

title_revisions-ng yaml
ActivePublic
Actions

Authored by • Pchelolo on Nov 15 2017, 11:47 AM.
Tags
None
Referenced Files
F10805007: title_revisions-ng yaml
Nov 15 2017, 11:47 AM
Subscribers
None
enwiki_T_title__revisions3WsaB42Wia1E_eq_KmoYTHe:
statement: |
CREATE KEYSPACE IF NOT EXISTS "enwiki_T_title__revisions3WsaB42Wia1E_eq_KmoYTHe" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
enwiki_T_title__revisions3WsaB42Wia1E_eq_KmoYTHe_meta:
statement: |
CREATE TABLE IF NOT EXISTS "enwiki_T_title__revisions3WsaB42Wia1E_eq_KmoYTHe".meta (
key text PRIMARY KEY,
value text
) WITH bloom_filter_fp_chance = 0.1
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
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 = '99PERCENTILE';
enwiki_T_title__revisions3WsaB42Wia1E_eq_KmoYTHe_data:
qKvData statement: |
CREATE TABLE "enwiki_T_title__revisions3WsaB42Wia1E_eq_KmoYTHe".data (
"_domain" text,
title text,
rev int,
comment text,
namespace int,
page_deleted int static,
page_id int,
redirect boolean,
restrictions set<text>,
tags set<text>,
tid timeuuid,
timestamp timestamp,
user_id int,
user_text text,
PRIMARY KEY (("_domain", title), rev)
) WITH CLUSTERING ORDER BY (rev DESC)
AND bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
AND compression = {'chunk_length_in_kb': '256', 'class': 'org.apache.cassandra.io.compress.DeflateCompressor'}
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 86400
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 = '99PERCENTILE';
# -----
commons_T_title__revisions3WsaB42Wia1E_eq_KmoYTH:
statement: |
CREATE KEYSPACE IF NOT EXISTS "commons_T_title__revisions3WsaB42Wia1E_eq_KmoYTH" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
commons_T_title__revisions3WsaB42Wia1E_eq_KmoYTH_meta:
statement: |
CREATE TABLE IF NOT EXISTS "commons_T_title__revisions3WsaB42Wia1E_eq_KmoYTH".meta (
key text PRIMARY KEY,
value text
) WITH bloom_filter_fp_chance = 0.1
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
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 = '99PERCENTILE';
commons_T_title__revisions3WsaB42Wia1E_eq_KmoYTH_data:
qKvData statement: |
CREATE TABLE "commons_T_title__revisions3WsaB42Wia1E_eq_KmoYTH".data (
"_domain" text,
title text,
rev int,
comment text,
namespace int,
page_deleted int static,
page_id int,
redirect boolean,
restrictions set<text>,
tags set<text>,
tid timeuuid,
timestamp timestamp,
user_id int,
user_text text,
PRIMARY KEY (("_domain", title), rev)
) WITH CLUSTERING ORDER BY (rev DESC)
AND bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
AND compression = {'chunk_length_in_kb': '256', 'class': 'org.apache.cassandra.io.compress.DeflateCompressor'}
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 86400
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 = '99PERCENTILE';
# -----
wikipedia_T_title__revisions3WsaB42Wia1E_eq_KmoY:
statement: |
CREATE KEYSPACE IF NOT EXISTS "wikipedia_T_title__revisions3WsaB42Wia1E_eq_KmoY" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
wikipedia_T_title__revisions3WsaB42Wia1E_eq_KmoY_meta:
statement: |
CREATE TABLE IF NOT EXISTS "wikipedia_T_title__revisions3WsaB42Wia1E_eq_KmoY".meta (
key text PRIMARY KEY,
value text
) WITH bloom_filter_fp_chance = 0.1
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
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 = '99PERCENTILE';
wikipedia_T_title__revisions3WsaB42Wia1E_eq_KmoY_data:
qKvData statement: |
CREATE TABLE "wikipedia_T_title__revisions3WsaB42Wia1E_eq_KmoY".data (
"_domain" text,
title text,
rev int,
comment text,
namespace int,
page_deleted int static,
page_id int,
redirect boolean,
restrictions set<text>,
tags set<text>,
tid timeuuid,
timestamp timestamp,
user_id int,
user_text text,
PRIMARY KEY (("_domain", title), rev)
) WITH CLUSTERING ORDER BY (rev DESC)
AND bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
AND compression = {'chunk_length_in_kb': '256', 'class': 'org.apache.cassandra.io.compress.DeflateCompressor'}
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 86400
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 = '99PERCENTILE';
# -----
others_T_title__revisions3WsaB42Wia1E_eq_KmoYTHe:
statement: |
CREATE KEYSPACE IF NOT EXISTS "others_T_title__revisions3WsaB42Wia1E_eq_KmoYTHe" WITH replication = {'class': 'NetworkTopologyStrategy', 'codfw': '3', 'eqiad': '3'} AND durable_writes = true;
others_T_title__revisions3WsaB42Wia1E_eq_KmoYTHe_meta:
statement: |
CREATE TABLE IF NOT EXISTS "others_T_title__revisions3WsaB42Wia1E_eq_KmoYTHe".meta (
key text PRIMARY KEY,
value text
) WITH bloom_filter_fp_chance = 0.1
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
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 = '99PERCENTILE';
others_T_title__revisions3WsaB42Wia1E_eq_KmoYTHe_data:
qKvData statement: |
CREATE TABLE "others_T_title__revisions3WsaB42Wia1E_eq_KmoYTHe".data (
"_domain" text,
title text,
rev int,
comment text,
namespace int,
page_deleted int static,
page_id int,
redirect boolean,
restrictions set<text>,
tags set<text>,
tid timeuuid,
timestamp timestamp,
user_id int,
user_text text,
PRIMARY KEY (("_domain", title), rev)
) WITH CLUSTERING ORDER BY (rev DESC)
AND bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
AND compression = {'chunk_length_in_kb': '256', 'class': 'org.apache.cassandra.io.compress.DeflateCompressor'}
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 86400
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 = '99PERCENTILE';
# -----
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits