想问问添加多级分区的sql怎么写?doris是否支持多级分区?
alter add partitions ?????
想问问添加多级分区的sql怎么写?doris是否支持多级分区?
alter add partitions ?????
CREATE TABLE tbl
(
k1 DATE,
k2 DATE,
k3 DATE
)
PARTITION BY RANGE(k1,k2) ()
DISTRIBUTED BY HASH(k1)
PROPERTIES
(
"replication_allocation" = "tag.location.default: 1"
);