-
Notifications
You must be signed in to change notification settings - Fork 8.3k
TTL_ONLY_DROP_PARTS does not drop empty parts #15180
Copy link
Copy link
Closed
Labels
comp-ttlTTL rules and TTL merges (moving/recompressing/rolling-up/deleting parts).TTL rules and TTL merges (moving/recompressing/rolling-up/deleting parts).unexpected behaviourResult is unexpected, but not entirely wrong at the same time.Result is unexpected, but not entirely wrong at the same time.
Description
I created table with following structure and inserted some test data.
Empty parts(rows = 0) still exists even if all rows from the table were deleted over TTL.
create table temp_ttl_partition_test
(
rec_date DateTime,
user_id String
)
engine = MergeTree
partition by formatDateTime(rec_date, '%Y%m%d%H')
ORDER BY user_id
TTL rec_date + interval 10 minute
SETTINGS ttl_only_drop_parts=1;
CH version = 20.5.2.7
Expected behavior: TTL_ONLY_DROP_PARTS must drop empty parts
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
comp-ttlTTL rules and TTL merges (moving/recompressing/rolling-up/deleting parts).TTL rules and TTL merges (moving/recompressing/rolling-up/deleting parts).unexpected behaviourResult is unexpected, but not entirely wrong at the same time.Result is unexpected, but not entirely wrong at the same time.
