【已解决】主键模型下是不能分区吗?目前用动态分区和自动分区都会报以下错误

Viewed 49

[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"
);
1 Answers

用法问题,目前已解决,参考问题中的解决方案。