Number of values in IN clause for clustering column

[Vova Shelgunov]

Hi All,

Let's imagine that I have the following schema:

CREATE TABLE IF NOT EXISTS history_data
(
    discriminator uuid,
    a bigint,
    b bigint,
    date date,
    data custom_type,
    PRIMARY KEY ((discriminator, a, b), date)
) WITH CLUSTERING ORDER BY (date DESC);

I want to delete the data from this table for a single pair (a and b)
and multiple dates:

DELETE FROM history_data WHERE discriminator = ... and a = 1 and b = 4
and date in (:list_of_dates)

How many dates can I pass in a single delete query without any
performance issues?


I planned to split the list_of_dates into multiple buckets and then
send an unlogged batch with all delete queries.


Thanks,

Uladzimir