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)
)
java网课推荐 PARTITION BY HASH (sup_qualify_id) PARTITIONS 5 stored AS kudu