当前位置: 代码迷 >> 综合 >> Doris0.15版本建表报错Failed to find enough host with storage medium and tag
  详细解决方案

Doris0.15版本建表报错Failed to find enough host with storage medium and tag

热度:64   发布时间:2023-11-28 00:47:30.0

报错

建表

CREATE TABLE `dwd_osms_organization` (`oid` int(11) NOT NULL COMMENT "",`name` varchar(255) NULL COMMENT "组织名称",`type` int(11) NULL COMMENT "组织类型,1公司/2项目组/3地区/4部门/5大组/6高级经理团队/7经理团队/8见习经理团队/9小组/10见习小组",`struct` int(11) NULL COMMENT "层级结构",`leaderName` varchar(255) NULL COMMENT "负责人名称",`leaderId` int(11) NULL COMMENT "负责人id",`leaderUserId` varchar(255) NULL COMMENT "负责人userId",`mobile` varchar(255) NULL COMMENT "负责人电话",`parent` int(11) NULL COMMENT "父级组织id",`organizationCreateTime` bigint(20) NULL COMMENT "组织表里的创建时间",`organizationUpdateTime` bigint(20) NULL COMMENT "组织表里的更新时间",`updateStamp` int(11) NULL COMMENT "doris更新时间"
) ENGINE=OLAP
UNIQUE KEY(`oid`)
COMMENT "dwd_osms_organization"
DISTRIBUTED BY HASH(`oid`) BUCKETS 10
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "V2"
);

报错

[2022-01-04 14:22:48] [42000][1064] errCode = 2, detailMessage = Failed to find enough host with storage medium and tag(HDD/{
    "location" : "default"}) in all backends. need: 1

解决

修改be.conf
原本

storage_root_path = /root/doris-storage

增加不同的medium

storage_root_path = /root/hdd/doris-storage,medium:hdd;/root/ssd/doris-storage,medium:ssd
  相关解决方案