Skip to content

TTL_ONLY_DROP_PARTS does not drop empty parts  #15180

@ikainazarov

Description

@ikainazarov

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

bug

Metadata

Metadata

Assignees

Labels

comp-ttlTTL rules and TTL merges (moving/recompressing/rolling-up/deleting parts).unexpected behaviourResult is unexpected, but not entirely wrong at the same time.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions