ENGINE = CnchMergeTree PARTITION BY toDate(event_date)` `ORDER BY` `(app_id, user_id, event_type);` `创建projection前写入2023-05-28分区测试数据` `INSERT INTO tea_data.events` `SELECT` `number / 100,` `number % 10,` `number % 3357,` `number % 166,` `number % 5,` `number % 40,` `'2023-05-28 05:11:55'` `FROM system.numbers LIMIT 100000;` `创建聚合projection` `ALTE...
[配置Linux实例Chrony服务(CentOS 7)](https://www.volcengine.com/docs/6396/119120)[配置Windows实例NTP服务](https://www.volcengine.com/docs/6396/130739)