使用UNIQUE KEY建表时候，用日期建分区，日期字段不是跟在id后面，一定要列出日期字段前面所有字段才能建分区吗

CREATE TABLE ods_crm_fnd_contract (
id varchar(32) not null comment '主键',
contract_no varchar(80) null comment '合同编号',
contract_date date not null comment '合同签订日期',
customer_id varchar(32) not null comment '客户id',
fruit_ids varchar(330) null comment '水果类型'
) ENGINE=OLAP
UNIQUE KEY(id,contract_no,contract_date)
COMMENT '销售合同表'
AUTO PARTITION BY RANGE (date_trunc(contract_date, 'year'))
()
DISTRIBUTED BY HASH(id) BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"dynamic_partition.enable" = "true",
"dynamic_partition.prefix" = "p",
"dynamic_partition.start" = "-50",
"dynamic_partition.end" = "5",
"dynamic_partition.time_unit" = "year"
);
我想按照update_time的年份分区，一定要按顺序，将update_time前面的每个字段都列出来才行吗，不列出来，会直接报错