impala建表语句原创,impala建立kudu表

CREATE TABLE fact_cpusup_qualify (
    sup_qualify_id BIGINT COMMENT '供应商资质id',
    qualify_type_id BIGINT COMMENT '资质类型id',
    qualify_type_name string COMMENT '资质类型名称',
    qualify_id BIGINT COMMENT '资质库资质id',
    qualify_code string COMMENT '资质编码',
    qualify_name string COMMENT '资质名称',
    qualify_status string COMMENT '资质库状态',
    qualify_enterprise_id bigint COMMENT 'qualify_enterprise_id',
    qualify_range string COMMENT '资质范围',
    qualify_date timestamp COMMENT '资质颁发时间',
    issue_ent string COMMENT '发布资质单位',
    exp_date timestamp COMMENT '资质过期时间',
    sup_qualify_type string COMMENT '供应商资质类型',
    supdoc_id bigint COMMENT '供应商档案id',
    sup_name string COMMENT '供应商名称',
    sup_code string COMMENT '供应商编码',
    exceed_days int COMMENT '距离过期日多少天',
    apply_date_day string COMMENT '供应商准入申请日',
    if_over string COMMENT '是否过期',
    sup_modify_time TIMESTAMP COMMENT '供应商最后修改时间',
    PRIMARY KEY (sup_qualify_id)
) PARTITION BY HASH (sup_qualify_id) PARTITIONS 5 stored AS kudu