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
impala建表语句原创,impala建立kudu表
最新推荐文章于 2024-01-04 14:16:41 发布