CREATE TABLE tiancheng_master.kjcq_tiancheng_jindie_summary_yingfu_duizhang_summary
(
danjutou_zhujian varchar(36) COMMENT ‘采购单据头主键’,
id varchar(36) ,
danjutou_date varchar(20) COMMENT ‘日期’,
mingxi_caigou_tuiliao_qty int SUM DEFAULT “0” COMMENT ‘数量’,
create_by varchar(50) COMMENT ‘创建人’,
create_time datetime COMMENT ‘创建日期’,
update_by varchar(50) COMMENT ‘更新人’,
update_time datetime COMMENT ‘更新日期’,
sys_org_code varchar(64) COMMENT ‘所属部门’
) AGGREGATE KEY(danjutou_zhujian)
DISTRIBUTED BY HASH(danjutou_zhujian)
PROPERTIES (
“replication_num” = “1”
);
不指定创建人,创建日期,更新人,更新日期这几个字段为聚合列.
