[1105] [HY000]: errCode = 2, detailMessage = The partition column could not be aggregated column
已解决(不能使用随机分桶,改为 HASH):
CREATE TABLE `log_object_model` (
`@@id` CHAR(34) NOT NULL COMMENT "日志唯一id",
`xxx` DATETIME(3) NOT NULL COMMENT "时间戳",
INDEX idx_message_english(`@message`) USING INVERTED PROPERTIES("parser" = "english") COMMENT '原始日志倒排索引_english',
INDEX idx_message_ngrambf (`@message`) USING NGRAM_BF PROPERTIES("gram_size"="3", "bf_size"="256") COMMENT '原始日志NGRAM'
)
UNIQUE KEY(`@@id`)
AUTO PARTITION BY RANGE (date_trunc(`xxx`, 'month'))
(
)
DISTRIBUTED BY HASH(`@@id`) BUCKETS AUTO
PROPERTIES
(
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
);