CREATE TABLE db1.test_local ( `id` UInt8, `EventDate` Date, `userID` UInt32 ) ENGINE = MergeTree PARTITION BY toYYYYMM(EventDate) ORDER BY id SETTINGS index_granularity = 8192将这张表分区改为天
时间: 2023-03-15 21:13:16 浏览: 107
Acegi_db1.rar_acegi
将上述表的分区方式改为按天,可以使用以下语句:ALTER TABLE db1.test_local PARTITION BY toYYYYDD(EventDate) ORDER BY id SETTINGS index_granularity = 8192;
阅读全文