报错

建表

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