动态分区创建失败提示Failed to find 3 backends for policy

[action2013]

根据文档尝试使用动态分区，提示错误：

errCode = 2, detailMessage = Failed to find 3 backends for policy: cluster|query|load|schedule|tags|medium: default_cluster|false|false|true|[{"location" : "default"}]|HDD

操作如下：

sql语句为：

CREATE TABLE IF NOT EXISTS unit_power4
(
    `unit_id` LARGEINT NOT NULL COMMENT "用户id",
    `date` DATE NOT NULL COMMENT "数据灌入日期时间",
    `power` BIGINT DEFAULT "0" COMMENT "电力"
)
UNIQUE KEY(`unit_id`, `date`)
PARTITION BY RANGE(`date`)
(
)
DISTRIBUTED BY HASH(`unit_id`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.create_history_partition" = "true",
"dynamic_partition.start" = "-10",
"dynamic_partition.end" = "10",
"dynamic_partition.prefix" = "p",
"dynamic_partition.replication_num" = "1"
);

运行环境基于快速开始 搭建

[LemonLiTree]

哪个版本？ 换"replication_num" = "1"试试呢

[action2013]

使用”replication_num“是可以的，我的版本是1.13

CREATE TABLE IF NOT EXISTS unit_power5
(
    `unit_id` LARGEINT NOT NULL COMMENT "用户id",
    `date` DATE NOT NULL COMMENT "数据灌入日期时间",
    `power` BIGINT DEFAULT "0" COMMENT "电力"
)
UNIQUE KEY(`unit_id`, `date`)
PARTITION BY RANGE(`date`)
(
)
DISTRIBUTED BY HASH(`unit_id`) BUCKETS 1
PROPERTIES (
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.create_history_partition" = "true",
"dynamic_partition.start" = "-10",
"dynamic_partition.end" = "10",
"dynamic_partition.prefix" = "p",
"replication_num" = "1",
"dynamic_partition.buckets" = "10"
);