This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new b4ff9f8e28b [opt](iceberg) add iceberg sys tables (#2356)
b4ff9f8e28b is described below
commit b4ff9f8e28b6ca15dd4bda31e2511b0f7b24d7e8
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Thu May 8 16:33:26 2025 +0800
[opt](iceberg) add iceberg sys tables (#2356)
## Versions
- [x] dev
- [ ] 3.0
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/lakehouse/catalogs/iceberg-catalog.md | 38 ++++++++++++++++++++++
.../current/lakehouse/catalogs/iceberg-catalog.md | 38 ++++++++++++++++++++++
2 files changed, 76 insertions(+)
diff --git a/docs/lakehouse/catalogs/iceberg-catalog.md
b/docs/lakehouse/catalogs/iceberg-catalog.md
index be5778cbb95..c164a715975 100644
--- a/docs/lakehouse/catalogs/iceberg-catalog.md
+++ b/docs/lakehouse/catalogs/iceberg-catalog.md
@@ -531,6 +531,44 @@ For an Iceberg Database, you must first drop all tables
under the database befor
* Object storage
+## System Tables
+
+Doris supports following system tables for iceberg table. These system tables
contains various metadata of Iceberg table.
+
+### snapshots
+
+Provides a detailed view of snapshots of the Iceberg table.
+
+```sql
+SELECT * FROM iceberg_meta(
+ 'table' = 'iceberg_ctl.iceberg_db.iceberg_tbl',
+ 'query_type' = 'snapshots'
+)
+```
+
+Or(Since 3.1.x):
+
+```
+SELECT * FROM iceberg_ctl.iceberg_db.iceberg_tbl$snapshost;
+```
+
+```
+*************************** 1. row ***************************
+ committed_at: 2024-11-28 11:07:29
+ snapshot_id: 8903826400153112036
+ parent_id: -1
+ operation: append
+manifest_list:
oss://path/to/metadata/snap-8903826400153112036-1-3835e66d-9a18-4cb0-b9b0-9ec80527ad8d.avro
+ summary:
{"added-data-files":"2","added-records":"3","added-files-size":"2742","changed-partition-count":"2","total-records":"3","total-files-size":"2742","total-data-files":"2","total-delete-files":"0","total-position-deletes":"0","total-equality-deletes":"0"}
+*************************** 2. row ***************************
+ committed_at: 2024-11-28 11:10:11
+ snapshot_id: 6099853805930794326
+ parent_id: 8903826400153112036
+ operation: append
+manifest_list:
oss://path/to/metadata/snap-6099853805930794326-1-dd46a1bd-219b-4fb0-bb46-ac441d8b3105.avro
+ summary:
{"added-data-files":"1","added-records":"1","added-files-size":"1367","changed-partition-count":"1","total-records":"4","total-files-size":"4109","total-data-files":"3","total-delete-files":"0","total-position-deletes":"0","total-equality-deletes":"0"}
+```
+
## Appendix
### Change Log
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/iceberg-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/iceberg-catalog.md
index 08f763f2e2a..f79e639d73f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/iceberg-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/iceberg-catalog.md
@@ -541,6 +541,44 @@ DROP DATABASE [IF EXISTS] iceberg.iceberg_db;
* 对象存储
+## 系统表
+
+Doris 支持以下 Iceberg 系统表，用于查看 Iceberg 表的各类元数据信息。
+
+### snapshots
+
+查询指定 Iceberg 表的 Snapshot 信息。
+
+```sql
+SELECT * FROM iceberg_meta(
+ 'table' = 'iceberg_ctl.iceberg_db.iceberg_tbl',
+ 'query_type' = 'snapshots'
+)
+```
+
+或（3.1.x 版本支持）：
+
+```
+SELECT * FROM iceberg_ctl.iceberg_db.iceberg_tbl$snapshost;
+```
+
+```
+*************************** 1. row ***************************
+ committed_at: 2024-11-28 11:07:29
+ snapshot_id: 8903826400153112036
+ parent_id: -1
+ operation: append
+manifest_list:
oss://path/to/metadata/snap-8903826400153112036-1-3835e66d-9a18-4cb0-b9b0-9ec80527ad8d.avro
+ summary:
{"added-data-files":"2","added-records":"3","added-files-size":"2742","changed-partition-count":"2","total-records":"3","total-files-size":"2742","total-data-files":"2","total-delete-files":"0","total-position-deletes":"0","total-equality-deletes":"0"}
+*************************** 2. row ***************************
+ committed_at: 2024-11-28 11:10:11
+ snapshot_id: 6099853805930794326
+ parent_id: 8903826400153112036
+ operation: append
+manifest_list:
oss://path/to/metadata/snap-6099853805930794326-1-dd46a1bd-219b-4fb0-bb46-ac441d8b3105.avro
+ summary:
{"added-data-files":"1","added-records":"1","added-files-size":"1367","changed-partition-count":"1","total-records":"4","total-files-size":"4109","total-data-files":"3","total-delete-files":"0","total-position-deletes":"0","total-equality-deletes":"0"}
+```
+
## 附录
### 版本更新记录
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
