This is an automated email from the ASF dual-hosted git repository.
jiafengzheng 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 ffcedfd196 code style
ffcedfd196 is described below
commit ffcedfd196e0afef89548848c76a2adb04dddfa2
Author: jiafeng.zhang <[email protected]>
AuthorDate: Fri Jul 22 15:17:58 2022 +0800
code style
code style
---
.../maint-monitor/tablet-repair-and-balance.md | 11 +++++------
.../Data-Definition-Statements/Create/CREATE-TABLE.md | 10 +++++-----
.../maint-monitor/tablet-repair-and-balance.md | 14 +++++++-------
.../Data-Definition-Statements/Create/CREATE-TABLE.md | 10 +++++-----
4 files changed, 22 insertions(+), 23 deletions(-)
diff --git a/docs/admin-manual/maint-monitor/tablet-repair-and-balance.md
b/docs/admin-manual/maint-monitor/tablet-repair-and-balance.md
index d6095ab594..5d0d2d9883 100644
--- a/docs/admin-manual/maint-monitor/tablet-repair-and-balance.md
+++ b/docs/admin-manual/maint-monitor/tablet-repair-and-balance.md
@@ -271,12 +271,11 @@ Duplicate status view mainly looks at the status of the
duplicate, as well as th
```
+-------+--------------------------------+-----------+------------+-------------------+----------------------+----------------------+--------------+----------------------------+-------------------------+-------------------+---------------------+----------------------+----------------------+------------------+-----------------------------+-----------------+-------------+------------+
- | DbId | DbName | TabletNum | HealthyNum |
ReplicaMissingNum | VersionIncompleteNum | ReplicaRelocatingNum | RedundantNum
| ReplicaMissingInClusterNum | ReplicaMissingForTagNum | ForceRedundantNum |
ColocateMismatchNum | ColocateRedundantNum | NeedFurtherRepairNum |
UnrecoverableNum | ReplicaCompactionTooSlowNum | InconsistentNum | OversizeNum
| CloningNum |
-
+-------+--------------------------------+-----------+------------+-------------------+----------------------+----------------------+--------------+----------------------------+-------------------------+-------------------+---------------------+----------------------+----------------------+------------------+-----------------------------+-----------------+-------------+------------+
- | 10005 | default_cluster:doris_audit_db | 84 | 84 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0 |
- | 13402 | default_cluster:ssb1 | 709 | 708 | 1
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0 |
- | 10108 | default_cluster:tpch1 | 278 | 278 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0 |
- | Total | 3 | 1071 | 1070 | 1
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0 |
+ | DbId | DbName | TabletNum | HealthyNum |
ReplicaMissingNum | VersionIncompleteNum | ReplicaRelocatingNum | RedundantNum
| ReplicaMissingInClusterNum | ReplicaMissingForTagNum | ForceRedundantNum |
ColocateMismatchNum | ColocateRedundantNum | NeedFurtherRepairNum |
UnrecoverableNum | ReplicaCompactionTooSlowNum | InconsistentNum | OversizeNum
| CloningNum |
+
+-------+--------------------------------+-----------+------------+-------------------+----------------------+----------------------+--------------+----------------------------+-------------------------+-------------------+---------------------+----------------------+----------------------+------------------+--------------|
10005 | default_cluster:doris_audit_db | 84 | 84 | 0
| 0 | 0 | 0 | 0
[...]
+ | 13402 | default_cluster:ssb1 | 709 | 708 | 1
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0 |
+ | 10108 | default_cluster:tpch1 | 278 | 278 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0 |
+ | Total | 3 | 1071 | 1070 | 1
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0 |
+-------+--------------------------------+-----------+------------+-------------------+----------------------+----------------------+--------------+----------------------------+-------------------------+-------------------+---------------------+----------------------+----------------------+------------------+-----------------------------+-----------------+-------------+------------+
```
diff --git
a/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
b/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
index 4935eb0af7..807c58bfbe 100644
---
a/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
+++
b/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
@@ -561,7 +561,7 @@ distribution_info
### Best Practice
-#### Partitioning and bucketing
+#### **1. Partitioning and bucketing**
A table must specify the bucket column, but it does not need to specify the
partition. For the specific introduction of partitioning and bucketing, please
refer to the [Data Division](../../../../data-table/data-partition.md) document.
@@ -571,11 +571,11 @@ At the same time, partitioning columns and bucketing
columns cannot be changed a
Therefore, it is recommended to confirm the usage method to build the table
reasonably before building the table.
-#### Dynamic Partition
+#### **2. Dynamic Partition**
The dynamic partition function is mainly used to help users automatically
manage partitions. By setting certain rules, the Doris system regularly adds
new partitions or deletes historical partitions. Please refer to [Dynamic
Partition](../../../../advanced/partition/dynamic-partition.md) document for
more help.
-#### Materialized View
+#### **3. Materialized View**
Users can create multiple materialized views (ROLLUP) while building a table.
Materialized views can also be added after the table is built. It is convenient
for users to create all materialized views at one time by writing in the table
creation statement.
@@ -585,12 +585,12 @@ If you add a materialized view in the subsequent use
process, if there is data i
For the introduction of materialized views, please refer to the document
[materialized views](../../../../advanced/materialized-view.md).
-#### Index
+#### **4. Index**
Users can create indexes on multiple columns while building a table. Indexes
can also be added after the table is built.
If you add an index in the subsequent use process, if there is data in the
table, you need to rewrite all the data, so the creation time of the index
depends on the current data volume.
-#### in_memory property
+#### **5. in_memory property**
The `"in_memory" = "true"` attribute was specified when the table was created.
Doris will try to cache the data blocks of the table in the PageCache of the
storage engine, which has reduced disk IO. However, this attribute does not
guarantee that the data block is permanently resident in memory, and is only
used as a best-effort identification.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/maint-monitor/tablet-repair-and-balance.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/maint-monitor/tablet-repair-and-balance.md
index 1dda79a60d..4d02a4b119 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/maint-monitor/tablet-repair-and-balance.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/maint-monitor/tablet-repair-and-balance.md
@@ -269,12 +269,12 @@ TabletScheduler 在每轮调度时，都会通过 LoadBalancer 来选择一定
```
+-------+--------------------------------+-----------+------------+-------------------+----------------------+----------------------+--------------+----------------------------+-------------------------+-------------------+---------------------+----------------------+----------------------+------------------+-----------------------------+-----------------+-------------+------------+
- | DbId | DbName | TabletNum | HealthyNum |
ReplicaMissingNum | VersionIncompleteNum | ReplicaRelocatingNum | RedundantNum
| ReplicaMissingInClusterNum | ReplicaMissingForTagNum | ForceRedundantNum |
ColocateMismatchNum | ColocateRedundantNum | NeedFurtherRepairNum |
UnrecoverableNum | ReplicaCompactionTooSlowNum | InconsistentNum | OversizeNum
| CloningNum |
+ | DbId | DbName | TabletNum | HealthyNum |
ReplicaMissingNum | VersionIncompleteNum | ReplicaRelocatingNum | RedundantNum
| ReplicaMissingInClusterNum | ReplicaMissingForTagNum | ForceRedundantNum |
ColocateMismatchNum | ColocateRedundantNum | NeedFurtherRepairNum |
UnrecoverableNum | ReplicaCompactionTooSlowNum | InconsistentNum | OversizeNum
| CloningNum |
+-------+--------------------------------+-----------+------------+-------------------+----------------------+----------------------+--------------+----------------------------+-------------------------+-------------------+---------------------+----------------------+----------------------+------------------+-----------------------------+-----------------+-------------+------------+
- | 10005 | default_cluster:doris_audit_db | 84 | 84 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 |
0 | 0 | 0 | 0 |
- | 13402 | default_cluster:ssb1 | 709 | 708 | 1
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 |
0 | 0 | 0 | 0 |
- | 10108 | default_cluster:tpch1 | 278 | 278 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 |
0 | 0 | 0 | 0 |
- | Total | 3 | 1071 | 1070 | 1
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 |
0 | 0 | 0 | 0 |
+ | 10005 | default_cluster:doris_audit_db | 84 | 84 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0 |
+ | 13402 | default_cluster:ssb1 | 709 | 708 | 1
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0 |
+ | 10108 | default_cluster:tpch1 | 278 | 278 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0 |
+ | Total | 3 | 1071 | 1070 | 1
| 0 | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | 0 |
+-------+--------------------------------+-----------+------------+-------------------+----------------------+----------------------+--------------+----------------------------+-------------------------+-------------------+---------------------+----------------------+----------------------+------------------+-----------------------------+-----------------+-------------+------------+
```
@@ -288,9 +288,9 @@ TabletScheduler 在每轮调度时，都会通过 LoadBalancer 来选择一定
```
+-----------------------+--------------------------+--------------------------+------------------+--------------------------------+-----------------------------+-----------------------+-------------------------+--------------------------+--------------------------+----------------------+---------------------------------+---------------------+-----------------+
- | ReplicaMissingTablets | VersionIncompleteTablets |
ReplicaRelocatingTablets | RedundantTablets | ReplicaMissingInClusterTablets |
ReplicaMissingForTagTablets | ForceRedundantTablets | ColocateMismatchTablets |
ColocateRedundantTablets | NeedFurtherRepairTablets | UnrecoverableTablets |
ReplicaCompactionTooSlowTablets | InconsistentTablets | OversizeTablets |
+ | ReplicaMissingTablets | VersionIncompleteTablets |
ReplicaRelocatingTablets | RedundantTablets | ReplicaMissingInClusterTablets |
ReplicaMissingForTagTablets | ForceRedundantTablets | ColocateMismatchTablets |
ColocateRedundantTablets | NeedFurtherRepairTablets | UnrecoverableTablets |
ReplicaCompactionTooSlowTablets | InconsistentTablets | OversizeTablets |
+-----------------------+--------------------------+--------------------------+------------------+--------------------------------+-----------------------------+-----------------------+-------------------------+--------------------------+--------------------------+----------------------+---------------------------------+---------------------+-----------------+
- | 14679 | |
| | |
| | |
| | |
| | |
+ | 14679 | |
| | |
| | |
| | |
| | |
+-----------------------+--------------------------+--------------------------+------------------+--------------------------------+-----------------------------+-----------------------+-------------------------+--------------------------+--------------------------+----------------------+---------------------------------+---------------------+-----------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
index a794ee7f5a..ae017e0f04 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
@@ -562,7 +562,7 @@ distribution_info
### Best Practice
-#### 分区和分桶
+#### **1. 分区和分桶**
一个表必须指定分桶列，但可以不指定分区。关于分区和分桶的具体介绍，可参阅
[数据划分](../../../../data-table/data-partition.md) 文档。
@@ -572,11 +572,11 @@ Doris 中的表可以分为分区表和无分区的表。这个属性在建表
所以建议在建表前，先确认使用方式来进行合理的建表。
-#### 动态分区
+#### **2. 动态分区**
动态分区功能主要用于帮助用户自动的管理分区。通过设定一定的规则，Doris 系统定期增加新的分区或删除历史分区。可参阅
[动态分区](../../../../advanced/partition/dynamic-partition.md) 文档查看更多帮助。
-#### 物化视图
+#### **3. 物化视图**
用户可以在建表的同时创建多个物化视图（ROLLUP）。物化视图也可以在建表之后添加。写在建表语句中可以方便用户一次性创建所有物化视图。
@@ -586,12 +586,12 @@ Doris 中的表可以分为分区表和无分区的表。这个属性在建表
关于物化视图的介绍，请参阅文档 [物化视图](../../../../advanced/materialized-view.md)。
-#### 索引
+#### **4. 索引**
用户可以在建表的同时创建多个列的索引。索引也可以在建表之后再添加。
如果在之后的使用过程中添加索引，如果表中已有数据，则需要重写所有数据，因此索引的创建时间取决于当前数据量。
-#### in_memory 属性
+#### **5. in_memory 属性**
当建表时指定了 `"in_memory" = "true"` 属性。则 Doris 会尽量将该表的数据块缓存在存储引擎的 PageCache
中，已减少磁盘IO。但这个属性不会保证数据块常驻在内存中，仅作为一种尽力而为的标识。
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
