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 3ee42a14b8c add: add system tables (#697)
3ee42a14b8c is described below
commit 3ee42a14b8ca974d68a542a3da03babdb19510fe
Author: Mingyu Chen <[email protected]>
AuthorDate: Thu May 30 21:22:08 2024 +0800
add: add system tables (#697)
Add new category `System Tables`
---
docs/admin-manual/system-tables/tables.md | 64 ++++++++++++++++++++++
.../docusaurus-plugin-content-docs/current.json | 6 +-
.../current/admin-manual/system-tables/tables.md | 64 ++++++++++++++++++++++
sidebars.json | 9 ++-
4 files changed, 141 insertions(+), 2 deletions(-)
diff --git a/docs/admin-manual/system-tables/tables.md
b/docs/admin-manual/system-tables/tables.md
new file mode 100644
index 00000000000..7c1c8c22482
--- /dev/null
+++ b/docs/admin-manual/system-tables/tables.md
@@ -0,0 +1,64 @@
+---
+{
+ "title": "tables",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Overview
+
+Stores all table information under the current catalog.
+
+## Database
+
+`information_schema`
+
+## Table Information
+
+| Column | Type | Description |
+|---|---|---|
+| TABLE_CATALOG | VARCHAR(512) | Catalog |
+| TABLE_SCHEMA | VARCHAR(64) | Database |
+| TABLE_NAME | VARCHAR(64) | Table |
+| TABLE_TYPE | VARCHAR(64) | Table type: SYSTEM VIEW, VIEW, BASE TABLE
|
+| ENGINE | VARCHAR(64) | Table engine type |
+| VERSION | BIGINT | Invalid value |
+| ROW_FORMAT | VARCHAR(10) | Invalid value |
+| TABLE_ROWS | BIGINT | Estimated row count |
+| AVG_ROW_LENGTH | BIGINT | Average row size |
+| DATA_LENGTH | BIGINT | Estimated table size |
+| MAX_DATA_LENGTH | BIGINT | Invalid value |
+| INDEX_LENGTH | BIGINT | Invalid value |
+| DATA_FREE | BIGINT | Invalid value |
+| AUTO_INCREMENT | BIGINT | Invalid value |
+| CREATE_TIME | DATETIME | Create time |
+| UPDATE_TIME | DATETIME | Update time |
+| CHECK_TIME | DATETIME | Invalid value |
+| TABLE_COLLATION | VARCHAR(32) | Fix value: utf-8 |
+| CHECKSUM | BIGINT | Invalid value |
+| CREATE_OPTIONS | VARCHAR(255) | Invalid value |
+| TABLE_COMMENT | VARCHAR(2048) | Comment |
+
+## Example
+
+None
+
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current.json
b/i18n/zh-CN/docusaurus-plugin-content-docs/current.json
index fc6fbcd1c3f..24e5e444ecd 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current.json
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current.json
@@ -179,6 +179,10 @@
"message": "配置管理",
"description": "The label for category Config in sidebar docs"
},
+ "sidebar.docs.category.System Tables": {
+ "message": "系统表",
+ "description": "The label for category System Table in sidebar docs"
+ },
"sidebar.docs.category.FE OPEN API": {
"message": "FE OPEN API",
"description": "The label for category FE OPEN API in sidebar docs"
@@ -367,4 +371,4 @@
"message": "存算分离",
"description": "Separation of Storage and Compute"
}
-}
\ No newline at end of file
+}
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/tables.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/tables.md
new file mode 100644
index 00000000000..c057272227c
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/tables.md
@@ -0,0 +1,64 @@
+---
+{
+ "title": "tables",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## 概述
+
+存储当前 Catalog 下所有的表信息。
+
+## 所属数据库
+
+`information_schema`
+
+## 表信息
+
+| 列名 | 类型 | 说明 |
+|---|---|---|
+| TABLE_CATALOG | VARCHAR(512) | 所属 Catalog |
+| TABLE_SCHEMA | VARCHAR(64) | 所属 Database |
+| TABLE_NAME | VARCHAR(64) | 表名称 |
+| TABLE_TYPE | VARCHAR(64) | 表类型，包括：SYSTEM VIEW、VIEW、BASE TABLE |
+| ENGINE | VARCHAR(64) | 表引擎类型 |
+| VERSION | BIGINT | 无效值 |
+| ROW_FORMAT | VARCHAR(10) | 无效值 |
+| TABLE_ROWS | BIGINT | 表预估行数 |
+| AVG_ROW_LENGTH | BIGINT | 表平均行大小 |
+| DATA_LENGTH | BIGINT | 表预估大小 |
+| MAX_DATA_LENGTH | BIGINT | 无效值 |
+| INDEX_LENGTH | BIGINT | 无效值 |
+| DATA_FREE | BIGINT | 无效值 |
+| AUTO_INCREMENT | BIGINT | 无效值 |
+| CREATE_TIME | DATETIME | 表创建时间 |
+| UPDATE_TIME | DATETIME | 表更新时间 |
+| CHECK_TIME | DATETIME | 无效值 |
+| TABLE_COLLATION | VARCHAR(32) | 固定值：utf-8 |
+| CHECKSUM | BIGINT | 无效值 |
+| CREATE_OPTIONS | VARCHAR(255) | 无效值 |
+| TABLE_COMMENT | VARCHAR(2048) | 表注释 |
+
+## 示例
+
+无
+
diff --git a/sidebars.json b/sidebars.json
index de5351eba98..c0b6c6026d8 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -389,6 +389,13 @@
"admin-manual/config/user-property"
]
},
+ {
+ "type": "category",
+ "label": "System Tables",
+ "items": [
+ "admin-manual/system-tables/tables"
+ ]
+ },
"admin-manual/audit-plugin",
{
"type": "category",
@@ -1521,4 +1528,4 @@
]
}
]
-}
\ No newline at end of file
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
