报错
建表
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