delete bitmap问题

CREATE TABLE test (
tag_value bigint NOT NULL ,
version bigint NOT NULL ,
hid smallint NULL ,
user_id bitmap BITMAP_UNION NOT NULL DEFAULT BITMAP_EMPTY
) ENGINE=OLAP
AGGREGATE KEY(tag_value, version, hid)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(hid) BUCKETS 8
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728"
);
我现在有一张表结构如上，需要对历史数据做清理，目前是使用delete from test where tag_value = xxx and version = xxx and hid = xxx; 循环进行删除，但是一旦执行后，内存就飙升，需要等很久才能降下来，有其他可以进行快速删除且对内存影响较小的方法么