Skip to content

Analytics: Support TTL on Non-Leading Primary Key Columns in Column-oriented tables #19895

@krasnovdm

Description

@krasnovdm

Description
Current TTL implementation in YDB Column-oriented tables only guarantees deletion for expired rows if the TTL column is the first column in the primary key (PK). When TTL is set on a non-leading PK column expired rows may not be deleted, leading to uncontrolled data growth

Proposed Solution
Extend TTL Support to Non-Leading PK Columns. Implement logic to efficiently expire rows using any PK column (not just the first).
Ensure shard-level compaction processes handle non-leading column TTL correctly.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions