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 e79717d6356 [opt](iceberg) opt iceberg sql (#2619)
e79717d6356 is described below
commit e79717d635669b750b0b345995eb459aed289764
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Fri Jul 11 23:11:14 2025 -0700
[opt](iceberg) opt iceberg sql (#2619)
## 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 | 15 ++++++++-------
.../current/lakehouse/catalogs/iceberg-catalog.md | 17 +++++++++--------
2 files changed, 17 insertions(+), 15 deletions(-)
diff --git a/docs/lakehouse/catalogs/iceberg-catalog.md
b/docs/lakehouse/catalogs/iceberg-catalog.md
index a61210d4c18..b0327ee20e7 100644
--- a/docs/lakehouse/catalogs/iceberg-catalog.md
+++ b/docs/lakehouse/catalogs/iceberg-catalog.md
@@ -865,6 +865,7 @@ You can use the following SQL to analyze the data
distribution and delete file c
WHEN content = 2 THEN 'EqualityDeleteFile'
ELSE 'Unknown'
END AS ContentType,
+ COUNT(*) AS FileNum,
SUM(file_size_in_bytes) AS SizeInBytes,
SUM(record_count) AS Records
FROM
@@ -872,13 +873,13 @@ You can use the following SQL to analyze the data
distribution and delete file c
GROUP BY
ContentType;
- +--------------------+-------------+---------+
- | ContentType | SizeInBytes | Records |
- +--------------------+-------------+---------+
- | EqualityDeleteFile | 1786 | 4 |
- | DataFile | 1981 | 5 |
- | PositionDeleteFile | 809 | 1 |
- +--------------------+-------------+---------+
+ +--------------------+---------+-------------+---------+
+ | ContentType | FileNum | SizeInBytes | Records |
+ +--------------------+---------+-------------+---------+
+ | EqualityDeleteFile | 2787 | 1432518 | 27870 |
+ | DataFile | 2787 | 4062416 | 38760 |
+ | PositionDeleteFile | 11 | 36608 | 10890 |
+ +--------------------+---------+-------------+---------+
```
### View Snapshot and Branch
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 f4bcd84fa61..c1329491424 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
@@ -873,6 +873,7 @@ ALTER TABLE iceberg_table ORDER BY (col_name1, col_name2,
...);
WHEN content = 2 THEN 'EqualityDeleteFile'
ELSE 'Unknown'
END AS ContentType,
+ COUNT(*) AS FileNum,
SUM(file_size_in_bytes) AS SizeInBytes,
SUM(record_count) AS Records
FROM
@@ -880,13 +881,13 @@ ALTER TABLE iceberg_table ORDER BY (col_name1, col_name2,
...);
GROUP BY
ContentType;
- +--------------------+-------------+---------+
- | ContentType | SizeInBytes | Records |
- +--------------------+-------------+---------+
- | EqualityDeleteFile | 1786 | 4 |
- | DataFile | 1981 | 5 |
- | PositionDeleteFile | 809 | 1 |
- +--------------------+-------------+---------+
+ +--------------------+---------+-------------+---------+
+ | ContentType | FileNum | SizeInBytes | Records |
+ +--------------------+---------+-------------+---------+
+ | EqualityDeleteFile | 2787 | 1432518 | 27870 |
+ | DataFile | 2787 | 4062416 | 38760 |
+ | PositionDeleteFile | 11 | 36608 | 10890 |
+ +--------------------+---------+-------------+---------+
```
### 查看快照和分支对应情况
@@ -926,4 +927,4 @@ ORDER BY
| 76492482642020578 | 2025-07-10 15:27:07.865000 | append | ["BRANCH:b3",
"TAG:t3"] |
| 1788715857849070138 | 2025-07-12 04:15:19.626000 | append |
["BRANCH:main", "TAG:t4", "TAG:t5"] |
+---------------------+----------------------------+-----------+-------------------------------------+
-```
\ No newline at end of file
+```
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
