为了更快的定位您的问题,请提供以下信息,谢谢
【详述】partition_live_number 在 主键表 模型下不生效
【是否存算分离】是
【StarRocks版本】3.2.4
CREATE TABLE `t_dwd_fac_pl_rema_rec` (
`rec_id` varchar(65533) NOT NULL COMMENT "记录id",
`part_tm` datetime NOT NULL COMMENT "分区时间",
`pl_id` varchar(65533) NULL COMMENT "停车场id",
`oprt_id` varchar(65533) NULL COMMENT "运营商id",
`total_vehic_lct` decimal(20, 0) NULL COMMENT "总车位",
`rema_vehic_lct` decimal(20, 0) NULL COMMENT "剩余车位",
`src_sys_cd` varchar(65533) NULL COMMENT "来源系统代码",
`etl_ld_tm` datetime NULL COMMENT "etl加载时间",
`etl_ld_job` varchar(65533) NULL COMMENT "etl加载作业"
) ENGINE=OLAP
PRIMARY KEY(`rec_id`, `part_tm`)
COMMENT "停车场剩余数量记录"
PARTITION BY date_trunc('day', part_tm)
DISTRIBUTED BY HASH(`rec_id`, `part_tm`)
PROPERTIES (
"replication_num" = "1",
"datacache.enable" = "true",
"storage_volume" = "def_volume",
"enable_async_write_back" = "false",
"enable_persistent_index" = "true",
"persistent_index_type" = "LOCAL",
"partition_live_number" = "7",
"compression" = "LZ4"
);
show partitions from nedw_dwd.t_dwd_fac_pl_rema_rec,显示有13个partition