This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 2d1d426cb64 [docs](system-table)update infomation_schema partitions
doc (#2417)
2d1d426cb64 is described below
commit 2d1d426cb64c483b709514e7dc980f68d9c09b52
Author: koarz <[email protected]>
AuthorDate: Sat Jun 21 09:28:02 2025 +0800
[docs](system-table)update infomation_schema partitions doc (#2417)
https://github.com/apache/doris/pull/51025
## Versions
- [x] dev
- [ ] 3.0
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../system-tables/information_schema/partitions.md | 70 +++++++++++++---------
.../system-tables/information_schema/partitions.md | 16 +++++
.../system-tables/information_schema/partitions.md | 16 +++++
.../system-tables/information_schema/partitions.md | 70 +++++++++++++---------
4 files changed, 118 insertions(+), 54 deletions(-)
diff --git a/docs/admin-manual/system-tables/information_schema/partitions.md
b/docs/admin-manual/system-tables/information_schema/partitions.md
index 2a25e972fff..0ea02d530fa 100644
--- a/docs/admin-manual/system-tables/information_schema/partitions.md
+++ b/docs/admin-manual/system-tables/information_schema/partitions.md
@@ -34,30 +34,46 @@ Show the Partition status of all tables in the database.
## Table Information
-| Column Name | Type | Description
|
-| ----------------------------- | ------------- |
--------------------------------- |
-| TABLE_CATALOG | varchar(64) | Catalog name
|
-| TABLE_SCHEMA | varchar(64) | Database name
|
-| TABLE_NAME | varchar(64) | Table name
|
-| PARTITION_NAME | varchar(64) | Partition name
|
-| SUBPARTITION_NAME | varchar(64) | Always empty
|
-| PARTITION_ORDINAL_POSITION | int | Ordinal position of the
partition |
-| SUBPARTITION_ORDINAL_POSITION | int | Always empty
|
-| PARTITION_METHOD | varchar(13) | Partition method
|
-| SUBPARTITION_METHOD | varchar(13) | Always empty
|
-| PARTITION_EXPRESSION | varchar(2048) | Partition expression
|
-| SUBPARTITION_EXPRESSION | varchar(2048) | Always empty
|
-| PARTITION_DESCRIPTION | text | Partition description
|
-| TABLE_ROWS | bigint |
|
-| AVG_ROW_LENGTH | bigint |
|
-| DATA_LENGTH | bigint |
|
-| MAX_DATA_LENGTH | bigint |
|
-| INDEX_LENGTH | bigint |
|
-| DATA_FREE | bigint |
|
-| CREATE_TIME | bigint |
|
-| UPDATE_TIME | datetime |
|
-| CHECK_TIME | datetime |
|
-| CHECKSUM | bigint |
|
-| PARTITION_COMMENT | text |
|
-| NODEGROUP | varchar(256) |
|
-| TABLESPACE_NAME | varchar(268) |
|
\ No newline at end of file
+| Column Name | Type | Description
|
+| ----------------------------- | ------------- |
------------------------------------ |
+| PARTITION_ID | bigint | Partitinon ID
|
+| TABLE_CATALOG | varchar(64) | Catalog name
|
+| TABLE_SCHEMA | varchar(64) | Database name
|
+| TABLE_NAME | varchar(64) | Table name
|
+| PARTITION_NAME | varchar(64) | Partition name
|
+| SUBPARTITION_NAME | varchar(64) | Always empty
|
+| PARTITION_ORDINAL_POSITION | int | Ordinal position of the
partition |
+| SUBPARTITION_ORDINAL_POSITION | int | Always empty
|
+| PARTITION_METHOD | varchar(13) | Partition method
|
+| SUBPARTITION_METHOD | varchar(13) | Always empty
|
+| PARTITION_EXPRESSION | varchar(2048) | Partition expression
|
+| SUBPARTITION_EXPRESSION | varchar(2048) | Always empty
|
+| PARTITION_DESCRIPTION | text | Partition description
|
+| TABLE_ROWS | bigint |
|
+| AVG_ROW_LENGTH | bigint |
|
+| DATA_LENGTH | bigint |
|
+| MAX_DATA_LENGTH | bigint |
|
+| INDEX_LENGTH | bigint |
|
+| DATA_FREE | bigint |
|
+| CREATE_TIME | bigint |
|
+| UPDATE_TIME | datetime |
|
+| CHECK_TIME | datetime |
|
+| CHECKSUM | bigint |
|
+| PARTITION_COMMENT | text |
|
+| NODEGROUP | varchar(256) |
|
+| TABLESPACE_NAME | varchar(268) |
|
+| LOCAL_DATA_SIZE | text | Partition local data size
|
+| REMOTE_DATA_SIZE | text | Partition remote data size
(cloud) |
+| STATE | text | Partition state
|
+| REPLICA_ALLOCATION | text | distribution of replicas of a
tablet |
+| REPLICA_NUM | int | replicas num
|
+| STORAGE_POLICY | text | Storage policy
|
+| STORAGE_MEDIUM | text | Storage medium
|
+| COOLDOWN_TIME_MS | text | Cooldown time
|
+| LAST_CONSISTENCY_CHECK_TIME | text | Last consistency check time
|
+| BUCKET_NUM | int | Partition bucket num
|
+| COMMITTED_VERSION | bigint | Last commited version
|
+| VISIBLE_VERSION | bigint | Current visible version
|
+| PARTITION_KEY | text | Partition key
|
+| RANGE | text | Partition range(min max
value) |
+| DISTRIBUTION | text | Distribution type
|
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/partitions.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/partitions.md
index f3c57b1e4bb..a4354ce26e3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/partitions.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/partitions.md
@@ -36,6 +36,7 @@ under the License.
| 列名 | 类型 | 说明 |
| :---------------------------- | :------------ | :------------------- |
+| PARTITION_ID | bigint | |
| TABLE_CATALOG | varchar(64) | Catalog 名字 |
| TABLE_SCHEMA | varchar(64) | Database 名字 |
| TABLE_NAME | varchar(64) | Table 名字 |
@@ -61,3 +62,18 @@ under the License.
| PARTITION_COMMENT | text | |
| NODEGROUP | varchar(256) | |
| TABLESPACE_NAME | varchar(268) | |
+| LOCAL_DATA_SIZE | text | Partition 本地数据大小 |
+| REMOTE_DATA_SIZE | text | Partition 远端数据大小(cloud) |
+| STATE | text | Partition 的状态 |
+| REPLICA_ALLOCATION | text | 描述 tablet 的副本分布 |
+| REPLICA_NUM | int | Partition 的副本数 |
+| STORAGE_POLICY | text | 存储策略 |
+| STORAGE_MEDIUM | text | 存储介质 |
+| COOLDOWN_TIME_MS | text | 冷却时间 |
+| LAST_CONSISTENCY_CHECK_TIME | text | 最后检查一致性的时间 |
+| BUCKET_NUM | int | 桶数 |
+| COMMITTED_VERSION | bigint | 最近一次被提交的版本 |
+| VISIBLE_VERSION | bigint | 当前可见版本 |
+| PARTITION_KEY | text | Partition 的键 |
+| RANGE | text | 分区的范围（最大最小值）|
+| DISTRIBUTION | text | 分区类型 |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/admin-manual/system-tables/information_schema/partitions.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/admin-manual/system-tables/information_schema/partitions.md
index 9de195b8af3..9e272172207 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/admin-manual/system-tables/information_schema/partitions.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/admin-manual/system-tables/information_schema/partitions.md
@@ -36,6 +36,7 @@ under the License.
| 列名 | 类型 | 说明 |
| :---------------------------- | :------------ | :------------------- |
+| PARTITION_ID | bigint | |
| TABLE_CATALOG | varchar(64) | Catalog 名字 |
| TABLE_SCHEMA | varchar(64) | Database 名字 |
| TABLE_NAME | varchar(64) | Table 名字 |
@@ -61,3 +62,18 @@ under the License.
| PARTITION_COMMENT | text | |
| NODEGROUP | varchar(256) | |
| TABLESPACE_NAME | varchar(268) | |
+| LOCAL_DATA_SIZE | text | Partition 本地数据大小 |
+| REMOTE_DATA_SIZE | text | Partition 远端数据大小(cloud) |
+| STATE | text | Partition 的状态 |
+| REPLICA_ALLOCATION | text | 描述 tablet 的副本分布 |
+| REPLICA_NUM | int | Partition 的副本数 |
+| STORAGE_POLICY | text | 存储策略 |
+| STORAGE_MEDIUM | text | 存储介质 |
+| COOLDOWN_TIME_MS | text | 冷却时间 |
+| LAST_CONSISTENCY_CHECK_TIME | text | 最后检查一致性的时间 |
+| BUCKET_NUM | int | 桶数 |
+| COMMITTED_VERSION | bigint | 最近一次被提交的版本 |
+| VISIBLE_VERSION | bigint | 当前可见版本 |
+| PARTITION_KEY | text | Partition 的键 |
+| RANGE | text | 分区的范围（最大最小值）|
+| DISTRIBUTION | text | 分区类型 |
diff --git
a/versioned_docs/version-3.0/admin-manual/system-tables/information_schema/partitions.md
b/versioned_docs/version-3.0/admin-manual/system-tables/information_schema/partitions.md
index 169f8f62728..9e82526bf0b 100644
---
a/versioned_docs/version-3.0/admin-manual/system-tables/information_schema/partitions.md
+++
b/versioned_docs/version-3.0/admin-manual/system-tables/information_schema/partitions.md
@@ -34,30 +34,46 @@ Show the Partition status of all tables in the database.
Before 3.0.2(inclusive)
## Table Information
-| Column Name | Type | Description
|
-| ----------------------------- | ------------- |
--------------------------------- |
-| TABLE_CATALOG | varchar(64) | Catalog name
|
-| TABLE_SCHEMA | varchar(64) | Database name
|
-| TABLE_NAME | varchar(64) | Table name
|
-| PARTITION_NAME | varchar(64) | Partition name
|
-| SUBPARTITION_NAME | varchar(64) | Always empty
|
-| PARTITION_ORDINAL_POSITION | int | Ordinal position of the
partition |
-| SUBPARTITION_ORDINAL_POSITION | int | Always empty
|
-| PARTITION_METHOD | varchar(13) | Partition method
|
-| SUBPARTITION_METHOD | varchar(13) | Always empty
|
-| PARTITION_EXPRESSION | varchar(2048) | Partition expression
|
-| SUBPARTITION_EXPRESSION | varchar(2048) | Always empty
|
-| PARTITION_DESCRIPTION | text | Partition description
|
-| TABLE_ROWS | bigint |
|
-| AVG_ROW_LENGTH | bigint |
|
-| DATA_LENGTH | bigint |
|
-| MAX_DATA_LENGTH | bigint |
|
-| INDEX_LENGTH | bigint |
|
-| DATA_FREE | bigint |
|
-| CREATE_TIME | bigint |
|
-| UPDATE_TIME | datetime |
|
-| CHECK_TIME | datetime |
|
-| CHECKSUM | bigint |
|
-| PARTITION_COMMENT | text |
|
-| NODEGROUP | varchar(256) |
|
-| TABLESPACE_NAME | varchar(268) |
|
\ No newline at end of file
+| Column Name | Type | Description
|
+| ----------------------------- | ------------- |
------------------------------------ |
+| PARTITION_ID | bigint | Partitinon ID
|
+| TABLE_CATALOG | varchar(64) | Catalog name
|
+| TABLE_SCHEMA | varchar(64) | Database name
|
+| TABLE_NAME | varchar(64) | Table name
|
+| PARTITION_NAME | varchar(64) | Partition name
|
+| SUBPARTITION_NAME | varchar(64) | Always empty
|
+| PARTITION_ORDINAL_POSITION | int | Ordinal position of the
partition |
+| SUBPARTITION_ORDINAL_POSITION | int | Always empty
|
+| PARTITION_METHOD | varchar(13) | Partition method
|
+| SUBPARTITION_METHOD | varchar(13) | Always empty
|
+| PARTITION_EXPRESSION | varchar(2048) | Partition expression
|
+| SUBPARTITION_EXPRESSION | varchar(2048) | Always empty
|
+| PARTITION_DESCRIPTION | text | Partition description
|
+| TABLE_ROWS | bigint |
|
+| AVG_ROW_LENGTH | bigint |
|
+| DATA_LENGTH | bigint |
|
+| MAX_DATA_LENGTH | bigint |
|
+| INDEX_LENGTH | bigint |
|
+| DATA_FREE | bigint |
|
+| CREATE_TIME | bigint |
|
+| UPDATE_TIME | datetime |
|
+| CHECK_TIME | datetime |
|
+| CHECKSUM | bigint |
|
+| PARTITION_COMMENT | text |
|
+| NODEGROUP | varchar(256) |
|
+| TABLESPACE_NAME | varchar(268) |
|
+| LOCAL_DATA_SIZE | text | Partition local data size
|
+| REMOTE_DATA_SIZE | text | Partition remote data size
(cloud) |
+| STATE | text | Partition state
|
+| REPLICA_ALLOCATION | text | distribution of replicas of a
tablet |
+| REPLICA_NUM | int | replicas num
|
+| STORAGE_POLICY | text | Storage policy
|
+| STORAGE_MEDIUM | text | Storage medium
|
+| COOLDOWN_TIME_MS | text | Cooldown time
|
+| LAST_CONSISTENCY_CHECK_TIME | text | Last consistency check time
|
+| BUCKET_NUM | int | Partition bucket num
|
+| COMMITTED_VERSION | bigint | Last commited version
|
+| VISIBLE_VERSION | bigint | Current visible version
|
+| PARTITION_KEY | text | Partition key
|
+| RANGE | text | Partition range(min max
value) |
+| DISTRIBUTION | text | Distribution type
|
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
