Skip to content

[lake] Support Altering Lake Table Properties via ALTER TABLE SET #2795

Description

@LiebingYu

Search before asking

  • I searched in the issues and found nothing similar.

Description

Task Overview:

Currently, Fluss does not allow users to alter Lake table properties (i.e., properties prefixed with the datalake format name, such as paimon.*) via ALTER TABLE ... SET (...) statements. Any attempt to modify such properties results in an InvalidConfigException.

Problem Statement:

When a user attempts to update Lake-specific table properties, such as partition configuration, the following error is thrown:

ALTER TABLE my_catalog.my_database.my_lake_table SET (
    'paimon.partition.timestamp-formatter' = 'yyyyMMdd',
    'paimon.partition.timestamp-pattern' = '$ds'
);
Caused by: org.apache.fluss.exception.InvalidConfigException: 
  Property 'paimon.partition.timestamp-pattern' is not supported to alter which is for datalake table.

This blanket restriction prevents users from updating valid and necessary Lake table configurations after table creation, such as:

  • paimon.partition.timestamp-formatter
  • paimon.partition.timestamp-pattern

Purpose:

Users need the ability to adjust Lake table properties post-creation without having to drop and recreate tables, which is disruptive in production environments.

Willingness to contribute

  • I'm willing to submit a PR!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No fields configured for Task.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions