create table test.T_idf_dws_test (
id int not null comment '主键',
field_1 varchar(2000) null comment '航线类型',
field_2 varchar(2000) null comment '起始站',
field_3 varchar(2000) null comment '抵达站',
field_4 varchar(2000) null comment '航班号',
field_5 varchar(2000) null comment '航段',
field_6 varchar(2000) null comment '主控',
field_7 bigint(20) null comment '3.1-3.29(淡季)',
field_8 bigint(20) null comment '3.30-3.31(平季)',
field_9 bigint(20) null comment '4.01(平季)',
field_10 bigint(20) null comment '4.02-4.08(旺季)',
field_11 bigint(20) null comment '4.09-4.28(平季)',
field_12 bigint(20) null comment '4.29-4.30(旺季)',
create_time datetime not null comment '创建时间',
create_by varchar(50) not null comment '创建人',
update_time datetime not null comment '修改时间',
update_by varchar(50) not null comment '修改人',
del_flag int(1) not null default 0 comment '删除状态：0-未删除，1-已删除',
del_id int not null default 0 comment '删除id',
) ENGINE=OLAP
comment '测试数据集上传'
distributed by hash(id) BUCKETS AUTO
properties(
"replication_allocation"= "tag.location.default: 2",
"estimate_partition_size" = "10G"
);
