Doris 存算分离集群 insert 操作报错

Question

按文档部署完成存算分离集群之后, insert 操作报错, 详细日志请看链接下载附件
FE日志：http://archive.uazw.com/tmp/fe.log
BE日志：http://archive.uazw.com/tmp/be.INFO
操作步骤

创建远程共享存储(无异常)

CREATE STORAGE VAULT IF NOT EXISTS hdfs_vault PROPERTIES (
    "type"="hdfs",                                     
    "fs.defaultFS"="hdfs://xxxxprdhadoop",             
    "path_prefix"="doris/cluster/01",                    
    "hadoop.security.authentication"="kerberos",        
    "hadoop.kerberos.principal"="xxx@XXX.COM",       
    "hadoop.kerberos.keytab"="/xxx/security/keytabs/hdp.keytab"         
);

创建数据库对象(无异常)

create database demo;
CREATE TABLE demo.unique_tbl
( 
`period_name` char(7) NOT NULL COMMENT '期间', 
`company` varchar(20) NOT NULL COMMENT '公司', 
`document` varchar(20) NOT NULL COMMENT '单据', 
`balance` varchar(20) NOT NULL COMMENT '勾销状态' 
) ENGINE=OLAP 
UNIQUE KEY(`period_name`, `company`, `document`) 
PARTITION BY LIST(`period_name`) 
(
  PARTITION P_2023_01 VALUES IN ("2023-01"), 
  PARTITION P_2023_02 VALUES IN ("2023-02"), 
  PARTITION P_2023_03 VALUES IN ("2023-03"), 
  PARTITION P_2023_04 VALUES IN ("2023-04"), 
  PARTITION P_2023_05 VALUES IN ("2023-05")
) 
DISTRIBUTED BY HASH(`period_name`
) BUCKETS AUTO 
PROPERTIES ( 
    "replication_num" = "3",
    "storage_vault_name" = "hdfs_vault",
    "enable_unique_key_merge_on_write" = "true"
);

插入数据(异常)

insert into demo.unique_tbl 
(period_name, company, document, balance)
values 
('2023-01', '3021', 'ebs_3021000001', '未勾销'),
('2023-01', '3022', 'ebs_3022000001', '未勾销');

版本: 3.0.2 存算分离
vault类型：hdfs 3.3.4

Doris 存算分离集群 insert 操作报错

0 Answers