[Feature] Support Iceberg system tables.

[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

2. 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

• I agree to follow this project's Code of Conduct

[ChenMiaoi]

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

[suxiaogang223]

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 :)

[github-actions]

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!