分区信息中的RowCount和实际分区中count(*)不一致

[U_1658385237533_1206]

【详述】分区信息中的RowCount和实际分区中count(*)不一致
【背景】
show partitions from common_user_action_detail_d;
显示分区2023-11-18有452691506 records 。

使用count(1)得到结果只有333739500 records。

【业务影响】
【是否存算分离】否
【StarRocks版本】2.5.6
【集群规模】1fe+3be
【机器信息】16Core +64GB
【联系方式】xiaobin@boundlessai.tech

[yuchen1019]

这个不是一个实时更新的值 有导入或者涉及分区的操作后面会有check 更新

[U_1658385237533_1206]

这个分区已经存在几个月了

[xiangguang]

meta 里记录了有一次 delete 操作刚好删除了 118952006 行：

{
“deprecated_rowset_id”: 0,
“partition_id”: 1463743,
“tablet_id”: 1463744,
“tablet_schema_hash”: 586796913,
“rowset_type”: “BETA_ROWSET”,
“rowset_state”: “VISIBLE”,
“start_version”: 0,
“end_version”: 3,
"num_rows": 118952006,
“total_disk_size”: 1572673311,
“data_disk_size”: 1572673311,
“index_disk_size”: 3843058,
“empty”: false,
“creation_time”: 1700449444,
“tablet_uid”: {
“hi”: -1564094385469823700,
“lo”: 8349970507520301000
},
“num_segments”: 2,
“rowset_id”: “020000000004c4642e499a29a83395ef3aff90928fc28586”,
“segments_overlap_pb”: “NONOVERLAPPING”,
“rowset_seg_id”: 0,
“total_row_size”: 6583941451
}, {
“deprecated_rowset_id”: 0,
“partition_id”: 1463743,
“tablet_id”: 1463744,
“txn_id”: 327197,
“tablet_schema_hash”: 586796913,
“rowset_type”: “BETA_ROWSET”,
“rowset_state”: “VISIBLE”,
“start_version”: 4,
“end_version”: 4,
“num_rows”: 0,
“total_disk_size”: 0,
“data_disk_size”: 0,
“index_disk_size”: 0,
"delete_predicate": {
"version": 4,
"sub_predicates": [“fdate=2023-11-18”]
},
“empty”: true,
“load_id”: {
“hi”: 0,
“lo”: 0
},
“creation_time”: 1700535955,
“tablet_uid”: {
“hi”: -1564094385469823700,
“lo”: 8349970507520301000
},
“num_segments”: 0,
“rowset_id”: “02000000000518ec2e499a29a83395ef3aff90928fc28586”,
“segments_overlap_pb”: “NONOVERLAPPING”,
“rowset_seg_id”: 0,
“total_row_size”: 0
}