【详述】明细模型(非分区表) 在创建表失败时提示： Failed to create partition
错误：### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Failed to create partition[fbz_realtime_export_may_not_arrive_tmp]. Timeout. Unfinished mark: 10002=13427028, 10003=13427028, 10004=134270
建表语句
CREATE TABLE fbz_realtime_export_may_not_arrive_tmp (
department_id bigint(20) NULL COMMENT “统计部门ID”,
department_name varchar(65533) NULL COMMENT “统计部门名称”,
trunk_line_code varchar(65533) NULL COMMENT “干线编码”,
waybill_number varchar(65533) NULL COMMENT “运单号”,
total_ticket bigint(20) NULL COMMENT “干线总票数”,
agent_total_package_num bigint(20) NULL COMMENT “干线代理总件数”,
agent_total_weight decimal(27, 6) NULL COMMENT “干线总重量”,
total_weight decimal(16, 4) NULL COMMENT “干线总经重”,
carriage_length varchar(65533) NULL COMMENT “干线车型”,
pickup_dispatch_area varchar(65533) NULL COMMENT “取调区域”,
latest_unloading_time bigint(20) NULL COMMENT “最晚卸货时间”,
charge_weight decimal(27, 6) NULL COMMENT “经重”,
service_type_common bigint(20) NULL COMMENT “原有服务方式”,
child_package_num bigint(20) NULL COMMENT “子件数”,
airport_original varchar(65533) NULL COMMENT “始发机场”,
airport_target varchar(65533) NULL COMMENT “目的机场”
) ENGINE=OLAP
DUPLICATE KEY(department_id)
COMMENT “OLAP”
DISTRIBUTED BY HASH(department_id) BUCKETS 1
PROPERTIES (
“replication_num” = “3”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”
);
求各路大神指导
