分区列支持 BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, LARGEINT, DATE, DATETIME, CHAR, VARCHAR 数据类型，分区值为枚举值。只有当数据为目标分区枚举值其中之一时，才可以命中分区。
CREATE TABLE `table1` (
`BUKRS` varchar(12) NULL,
`GJAHR` varchar(12) NOT NULL,
`BLART` varchar(6) NULL,
`BLDAT` datetime NULL,
`XFREF2` varchar(36) NULL,
`XFREF3` varchar(60) NULL
) ENGINE=OLAP
UNIQUE KEY(`BUKRS`, `GJAHR`)
COMMENT 'OLAP'
PARTITION BY LIST(`GJAHR`)
(PARTITION p2020 VALUES IN ("2020"),
PARTITION p2021 VALUES IN ("2021"),
PARTITION p2022 VALUES IN ("2022"))
DISTRIBUTED BY HASH(`BUKRS`) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"in_memory" = "false",
"storage_format" = "V2",
"disable_auto_compaction" = "false"
);
ALTER TABLE ads.ads_sap_fidoc1 ADD PARTITION p2031 VALUES in ("2031");
参考链接：
https://doris.apache.org/zh-CN/docs/table-design/data-partition#list-%E5%88%86%E5%8C%BA
标签：varchar,分区,PARTITION,list,字段,VALUES,NULL,doris From： https://www.cnblogs.com/chong-zuo3322/p/18424024