Slide 21
Slide 21 text
ύʔςΟγϣϯͷΈ߹Θͤྫ
SELECT user_id
FROM cassandra.main.event_counts
WHERE
service_id = 1 AND event_id = 2
AND dt IN ('2020-11-18', '2020-11-19', '2020-11-20')
AND bucket IN (0, 1, ..., 63) AND occurrence >= 1;
SELECT DISTINCT service_id, event_id, dt, bucket FROM main.event_counts
WHERE service_id = 1 AND event_id = 2 AND dt = '2020-11-18' AND bucket = 0;
SELECT DISTINCT service_id, event_id, dt, bucket FROM main.event_counts
WHERE service_id = 1 AND event_id = 2 AND dt = '2020-11-19' AND bucket = 0;
...
1 x 1 x 3 x 64 = 192 queries
Presto SQL
CQL
NativeCassandraSession#getPartitions