discorecs/discorecs_schema.cql at master · maxmckittrick/discorecs · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180

CREATE KEYSPACE discorecs WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '3'}  AND durable_writes = true;

CREATE TABLE discorecs.releases_scored (
    release_id int PRIMARY KEY,
    artist text,
    blues_score int,
    brass_score int,
    childrens_score int,
    classical_score int,
    electronic_score int,
    folk_score int,
    funk_score int,
    genre text,
    hiphop_score int,
    jazz_score int,
    latin_score int,
    nonmusic_score int,
    pop_score int,
    reggae_score int,
    rock_score int,
    stagescreen_score int,
    title text
) WITH 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': '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';

CREATE TABLE discorecs.users_staging (
    user_id ascii PRIMARY KEY,
    blues_score int,
    brass_score int,
    childrens_score int,
    classical_score int,
    collection list<int>,
    electronic_score int,
    folk_score int,
    funk_score int,
    hiphop_score int,
    jazz_score int,
    latin_score int,
    nonmusic_score int,
    pop_score int,
    recommended_release int,
    recommended_user ascii,
    reggae_score int,
    rock_score int,
    stagescreen_score int
) WITH 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': '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';

CREATE TABLE discorecs.users (
    user_id ascii PRIMARY KEY,
    artist text,
    artists text,
    blues_score int,
    brass_score int,
    childrens_score int,
    classical_score int,
    collection list<int>,
    electronic_score int,
    folk_score int,
    funk_score int,
    hiphop_score int,
    jazz_score int,
    latin_score int,
    nonmusic_score int,
    pop_score int,
    recommended_release int,
    recommended_user ascii,
    reggae_score int,
    rock_score int,
    stagescreen_score int,
    title text
) WITH 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': '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';

CREATE TABLE discorecs.releases (
    release_id int PRIMARY KEY,
    artist text,
    blues_score int,
    brass_score int,
    childrens_score int,
    classical_score int,
    electronic_score int,
    folk_score int,
    funk_score int,
    genre text,
    hiphop_score int,
    jazz_score int,
    latin_score int,
    nonmusic_score int,
    pop_score int,
    reggae_score int,
    rock_score int,
    stagescreen_score int,
    title text
) WITH 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': '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';

CREATE TABLE discorecs.users_scored (
    user_id ascii PRIMARY KEY,
    blues_score int,
    brass_score int,
    childrens_score int,
    classical_score int,
    collection list<int>,
    electronic_score int,
    folk_score int,
    funk_score int,
    hiphop_score int,
    jazz_score int,
    latin_score int,
    nonmusic_score int,
    pop_score int,
    recommended_release int,
    recommended_user ascii,
    reggae_score int,
    rock_score int,
    stagescreen_score int
) WITH 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': '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';