同样的DDL,在测试环境使用mysql client建表没问题
上生产环境用同样的DDL就出现以下错误
ERROR 1105 (HY000): NullPointerException
两边环境都是一样的doris版本2.1.1,透过helm k8s部署
唯一不一样在于生产环境是3 fe 3 be,而测试环境为1 fe 1 be
DDL去掉敏感资料如下
CREATE TABLE DWD_b_Mysql_o_m (
origin_table VARCHAR,
id BIGINT,
date_utc8 DATE,
auto_id BIGINT NOT NULL AUTO_INCREMENT,
commit_datetime DATETIME DEFAULT current_timestamp(0) on update current_timestamp(0),
b_is_1 INT,
b_is_2 INT,
b_o_id BIGINT,
b_u_id BIGINT,
b_sfe DECIMAL(38,0),
b_t_sra DECIMAL(38,0),
c_b_sf DECIMAL(38,0),
c_dis_sra DECIMAL(38,0),
c_sf DECIMAL(38,0),
c_sf_kind INT,
c_t_sf DECIMAL(38,0),
c_t_sra DECIMAL(38,0),
dis_sra DECIMAL(38,0),
is_up INT,
kind INT,
m_b_dis_sra DECIMAL(38,0),
m_c_sam DECIMAL(38,0),
m_p_dis_sra DECIMAL(38,0),
m_sam DECIMAL(38,0),
m_spr DECIMAL(38,0),
mat_id VARCHAR(128),
s_is_1 INT,
s_is_2 INT,
s_o_id BIGINT,
s_u_id BIGINT,
sf DECIMAL(38,0),
sf_kind INT,
t_sfee DECIMAL(38,0),
t_srate DECIMAL(38,0),
u_t_srate DECIMAL(38,0),
b_sra DECIMAL(38,0),
c_b_sra DECIMAL(38,0),
ba STRING,
cen STRING,
datetime_utc8 DATETIME
)
UNIQUE KEY(`origin_table`,`id`,`date_utc8`)
DISTRIBUTED BY HASH(`date_utc8`) BUCKETS AUTO
PROPERTIES (
"replication_allocation" = "tag.location.default: 3"
);
请问哪边有问题呢?感谢!