using the example from documentation, I get an error No viable statement for input ‘PARTITION BY tenant_id,’. :
CREATE TABLE activity (
tenant_id INT,
dt DATETIME,
id BIGINT
)
DUPLICATE KEY(dt, id)
PARTITION BY tenant_id, date_trunc('MONTH', dt)
DISTRIBUTED BY HASH(id);
example taken from Partitioning | StarRocks