说明:
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.插入数据结果
3.查看分区结果