Skip to content

[Feature] Support Iceberg system tables. #48278

Closed

Description

@wuwenchi

Search before asking

  • I had searched in the issues and found no similar issues.

Description

  1. Support querying system tables via '$', like:
select * from [catalog.][db.]table$system_table;

The system tables that need to be supported include:

  • refs
  • snapshots (replace with 'iceberg_meta')
  • manifests
  • files
  • partitions
  1. These system tables also support timestamp travel queries, like:
select * from [catalog.][db.]table$partitions VERSION AS OF 10963874102873

Use case

No response

Related issues

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Activity

  1. added
    kind/featureCategorizes issue or PR as related to a new feature.
    on Feb 25, 2025
  2. ChenMiaoi commented on Feb 28, 2025

    @ChenMiaoi
    Contributor

    Im interesting this task, could u give me more information about how to start it or the relative pr?

  3. suxiaogang223 commented on Jun 24, 2025

    @suxiaogang223
    Member

    Im interesting this task, could u give me more information about how to start it or the relative pr?

    Hi✋, this issue had been implemented by #51190. If you are interested, you can check out another similar issue for paimon #48279. And we can discuss how to implement this feature based on paimon's code :)

  4. github-actions commented on Dec 22, 2025

    @github-actions
    Contributor

    We're closing this issue because it hasn't been updated in a while.
    If you'd like to revive this issue, please reopen it and feel free a maintainer to remove the Stale tag!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Stalekind/featureCategorizes issue or PR as related to a new feature.

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions