自动分区分区名后面多一个数据什么如何处理

Viewed 32

说明:
1)doris 版本3.0.4 存算一体
1.建表语句
CREATE TABLE IF NOT EXISTS DWD_MICS_POINT_STATUS_MONTH(
DT INT,
TS BIGINT,
ENTITY_NAME VARCHAR(255),
ENTITY_ID BIGINT,
VALUE FLOAT,
LOCATION_ID INT,
DATA_TYPE VARCHAR(255)
) UNIQUE KEY (DT,TS,ENTITY_NAME) AUTO PARTITION BY LIST(DT) () DISTRIBUTED BY HASH(ENTITY_NAME) BUCKETS 1 properties(
"replication_num" = "1"
);

2.插入数据结果
7c53af83a5ae3a11245ef746bfc9bc6.png
3.查看分区结果
713c10dba4f413bd42748315d0802bd.png

1 Answers