create table ddl出现NullPointerException

Viewed 62

同样的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"
);

请问哪边有问题呢?感谢!

1 Answers

麻烦贴一下fe.log中的完整报错