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 2423ebda757 [doc](tiered) Add dynamic partition migration (#874)
2423ebda757 is described below
commit 2423ebda75707aafa31d41b061277c626131f9e7
Author: deardeng <[email protected]>
AuthorDate: Sun Aug 11 17:38:03 2024 +0800
[doc](tiered) Add dynamic partition migration (#874)
---
.../Alter/ALTER-TABLE-PROPERTY.md | 11 ++++
.../Create/CREATE-DATABASE.md | 4 ++
.../Create/CREATE-TABLE.md | 12 +---
docs/table-design/data-partition.md | 40 ++-----------
docs/table-design/overview.md | 4 ++
.../tiered-storage/diff-disk-medium-migration.md | 66 ++++++++++++++++++++++
.../Alter/ALTER-TABLE-PROPERTY.md | 11 ++++
.../Create/CREATE-DATABASE.md | 4 ++
.../Create/CREATE-TABLE.md | 12 +---
.../current/table-design/data-partition.md | 34 +++--------
.../current/table-design/overview.md | 5 ++
.../tiered-storage/diff-disk-medium-migration.md | 62 ++++++++++++++++++++
sidebars.json | 1 +
13 files changed, 182 insertions(+), 84 deletions(-)
diff --git
a/docs/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-TABLE-PROPERTY.md
b/docs/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-TABLE-PROPERTY.md
index 24e8bd917cc..155dcc97a5c 100644
---
a/docs/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-TABLE-PROPERTY.md
+++
b/docs/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-TABLE-PROPERTY.md
@@ -30,6 +30,17 @@ under the License.
ALTER TABLE PROPERTY
+:::caution
+Differences between Partition Attributes and Table Attributes
+- Partition attributes generally focus on the number of buckets (buckets),
storage medium (storage_medium), replication num (replication_num), and
hot/cold data separation policies (storage_policy).
+ - For existing partitions, you can use ALTER TABLE {tableName} MODIFY
PARTITION ({partitionName}) SET ({key}={value}) to modify them, but the number
of buckets (buckets) cannot be changed.
+ - For not-created dynamic partitions, you can use ALTER TABLE {tableName}
SET (dynamic_partition.{key} = {value}) to modify their attributes.
+ - For not-created auto partitions, you can use ALTER TABLE {tableName} SET
({key} = {value}) to modify their attributes.
+ - If users want to modify partition attributes, they need to modify the
attributes of the already created partitions, as well as the attributes of
not-created partitions.
+- Aside from the above attributes, all others are at the table level.
+- For the specific attributes, please refer to [create table
attributes](../../../../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md#properties)
+:::
+
### Description
This statement is used to modify the properties of an existing table. This
operation is synchronous, and the return of the command indicates the
completion of the execution.
diff --git
a/docs/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-DATABASE.md
b/docs/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-DATABASE.md
index 49b7cf0537b..db6f3fe8296 100644
---
a/docs/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-DATABASE.md
+++
b/docs/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-DATABASE.md
@@ -68,6 +68,10 @@ CREATE DATABASE [IF NOT EXISTS] db_name
);
````
+:::caution
+If the create table statement has attributes replication_allocation or
replication_num, then the default replica distribution policy of the database
will not take effect.
+:::
+
### Keywords
````text
diff --git
a/docs/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
b/docs/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
index 776cdece796..0d198c4f7a6 100644
---
a/docs/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
+++
b/docs/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
@@ -483,17 +483,7 @@ Set table properties. The following attributes are
currently supported:
* Dynamic partition related
- The relevant parameters of dynamic partition are as follows:
-
-* `dynamic_partition.enable`: Used to specify whether the dynamic partition
function at the table level is enabled. The default is true.
-* `dynamic_partition.time_unit:` is used to specify the time unit for
dynamically adding partitions, which can be selected as DAY (day), WEEK (week),
MONTH (month), YEAR (year), HOUR (hour).
-* `dynamic_partition.start`: Used to specify how many partitions to delete
forward. The value must be less than 0. The default is Integer.MIN_VALUE.
-* `dynamic_partition.end`: Used to specify the number of partitions created in
advance. The value must be greater than 0.
-* `dynamic_partition.prefix`: Used to specify the partition name prefix to be
created. For example, if the partition name prefix is p, the partition name
will be automatically created as p20200108.
-* `dynamic_partition.buckets`: Used to specify the number of partition buckets
that are automatically created.
-* `dynamic_partition.create_history_partition`: Whether to create a history
partition.
-* `dynamic_partition.history_partition_num`: Specify the number of historical
partitions to be created.
-* `dynamic_partition.reserved_history_periods`: Used to specify the range of
reserved history periods.
+ References related to dynamic partitioning[Data Partitioning-Dynamic
partitioning](../../../../table-design/data-partition.md#Dynamic partitioning)
### Example
diff --git a/docs/table-design/data-partition.md
b/docs/table-design/data-partition.md
index ed863ab76b7..0a959041e72 100644
--- a/docs/table-design/data-partition.md
+++ b/docs/table-design/data-partition.md
@@ -462,6 +462,10 @@ The rules of dynamic partition are prefixed with
`dynamic_partition.`:
The starting offset of the dynamic partition, usually a negative number.
Depending on the `time_unit` attribute, based on the current day (week /
month), the partitions with a partition range before this offset will be
deleted. If not filled, the default is `-2147483648`, that is, the history
partition will not be deleted.
+:::caution
+Note that if the user sets history_partition_num (> 0), the starting partition
for creating dynamic partitions will use max(start, -history_partition_num),
and when deleting historical partitions, the range up to start will still be
retained, where start < 0.
+:::
+
- `dynamic_partition.end`(required parameters)
The end offset of the dynamic partition, usually a positive number.
According to the difference of the `time_unit` attribute, the partition of the
corresponding range is created in advance based on the current day (week /
month).
@@ -489,6 +493,7 @@ The rules of dynamic partition are prefixed with
`dynamic_partition.`:
When `time_unit` is` MONTH`, this parameter is used to specify the start
date of each month. The value ranges from 1 to 28. 1 means the 1st of every
month, and 28 means the 28th of every month. The default is 1, which means that
every month starts at 1st. The 29, 30 and 31 are not supported at the moment to
avoid ambiguity caused by lunar years or months.
+- Doris supports multi-level storage with SSD and HDD tiers. For more details,
please refer to [tiered-storage](./tiered-storage/diff-disk-medium-migration.md)
- `dynamic_partition.create_history_partition`
@@ -500,30 +505,6 @@ The rules of dynamic partition are prefixed with
`dynamic_partition.`:
When `create_history_partition` is `true`, this parameter is used to specify
the number of history partitions. The default value is -1, which means it is
not set.
-- `dynamic_partition.hot_partition_num`
-
- Specify how many of the latest partitions are hot partitions. For hot
partition, the system will automatically set its `storage_medium` parameter to
SSD, and set `storage_cooldown_time`.
-
- :::tip
-
- If there is no SSD disk path under the storage path, configuring this
parameter will cause dynamic partition creation to fail.
-
- :::
-
- `hot_partition_num` is all partitions in the previous n days and in the
future.
-
- Let us give an example. Suppose today is 2021-05-20, partition by day, and
the properties of dynamic partition are set to: hot_partition_num=2, end=3,
start=-3. Then the system will automatically create the following partitions,
and set the `storage_medium` and `storage_cooldown_time` properties:
-
- ```sql
- p20210517: ["2021-05-17", "2021-05-18") storage_medium=HDD
storage_cooldown_time=9999-12-31 23:59:59
- p20210518: ["2021-05-18", "2021-05-19") storage_medium=HDD
storage_cooldown_time=9999-12-31 23:59:59
- p20210519: ["2021-05-19", "2021-05-20") storage_medium=SSD
storage_cooldown_time=2021-05-21 00:00:00
- p20210520: ["2021-05-20", "2021-05-21") storage_medium=SSD
storage_cooldown_time=2021-05-22 00:00:00
- p20210521: ["2021-05-21", "2021-05-22") storage_medium=SSD
storage_cooldown_time=2021-05-23 00:00:00
- p20210522: ["2021-05-22", "2021-05-23") storage_medium=SSD
storage_cooldown_time=2021-05-24 00:00:00
- p20210523: ["2021-05-23", "2021-05-24") storage_medium=SSD
storage_cooldown_time=2021-05-25 00:00:00
- ```
-
- `dynamic_partition.reserved_history_periods`
@@ -553,17 +534,6 @@ The rules of dynamic partition are prefixed with
`dynamic_partition.`:
Otherwise, every `[...,...]` in `reserved_history_periods` is a couple of
properties, and they should be set at the same time. And the first date can't
be larger than the second one.
-- `dynamic_partition.storage_medium`
-
-
- :::info Note
- This parameteres is supported since Doris version 1.2.3
- :::
-
- Specifies the default storage medium for the created dynamic partition. HDD
is the default, SSD can be selected.
-
- Note that when set to SSD, the `hot_partition_num` property will no longer
take effect, all partitions will default to SSD storage media and the cooldown
time will be 9999-12-31 23:59:59.
-
### Create history partition rules
When `create_history_partition` is `true`, i.e. history partition creation is
enabled, Doris determines the number of history partitions to be created based
on `dynamic_partition.start` and `dynamic_partition.history_partition_num`.
diff --git a/docs/table-design/overview.md b/docs/table-design/overview.md
index cb58343dc06..b62473fb6ee 100644
--- a/docs/table-design/overview.md
+++ b/docs/table-design/overview.md
@@ -32,6 +32,10 @@ Users can use the [CREATE
TABLE](../sql-manual/sql-statements/Data-Definition-St
In Doris, table names are case-sensitive by default. You can configure
[lower_case_table_names](../admin-manual/config/fe-config.md)to make them
case-insensitive during the initial cluster setup. The default maximum length
for table names is 64 bytes, but you can change this by configuring
[table_name_length_limit](../admin-manual/config/fe-config.md). It is not
recommended to set this value too high. For syntax on creating tables, please
refer to [CREATE TABLE](../sql-manual/sql-stateme [...]
+## Table property
+
+In the Doris CREATE TABLE statement, you can specify various [table
properties](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md#properties).
Among them, the number of buckets (buckets), storage medium (storage_medium),
replication num (replication_num), and hot/cold storage policy (storage_policy)
properties apply to the partitions. That is, once a partition is created, it
will have its own set of properties. Modifying the table properties will only
affect [...]
+
## Notes
diff --git a/docs/table-design/tiered-storage/diff-disk-medium-migration.md
b/docs/table-design/tiered-storage/diff-disk-medium-migration.md
new file mode 100644
index 00000000000..1201bba2b07
--- /dev/null
+++ b/docs/table-design/tiered-storage/diff-disk-medium-migration.md
@@ -0,0 +1,66 @@
+---
+{
+"title": "SSD and HDD tiered storage",
+"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.
+-->
+
+It is possible to set parameters to create dynamic partitions on the
corresponding disk types, while supporting data migration between (HDD, SSD)
disk types based on the data's hot and cold characteristics, which can
accelerate the read and write performance of Doris.
+
+- `dynamic_partition.hot_partition_num`
+
+ Doris supports data migration between different disk types (HDD, SSD) based
on the cold/hot characteristics of the data, which can accelerate read and
write performance. Users can set partition parameters to create dynamic
partitions on the corresponding disk types.
+
+ For the 'dynamic_partition' parameter, please refer to
[data-partition](../../table-design/data-partition.md#dynamic-partitioning)."
+
+
+
+ :::tip
+
+ If there is no SSD disk path under the storage path, configuring this
parameter will cause dynamic partition creation to fail.
+
+ :::
+
+ `hot_partition_num` is all partitions in the previous n days and in the
future.
+
+ Let us give an example. Suppose today is 2021-05-20, partition by day, and
the properties of dynamic partition are set to: hot_partition_num=2, end=3,
start=-3. Then the system will automatically create the following partitions,
and set the `storage_medium` and `storage_cooldown_time` properties:
+
+ ```sql
+ p20210517: ["2021-05-17", "2021-05-18") storage_medium=HDD
storage_cooldown_time=9999-12-31 23:59:59
+ p20210518: ["2021-05-18", "2021-05-19") storage_medium=HDD
storage_cooldown_time=9999-12-31 23:59:59
+ p20210519: ["2021-05-19", "2021-05-20") storage_medium=SSD
storage_cooldown_time=2021-05-21 00:00:00
+ p20210520: ["2021-05-20", "2021-05-21") storage_medium=SSD
storage_cooldown_time=2021-05-22 00:00:00
+ p20210521: ["2021-05-21", "2021-05-22") storage_medium=SSD
storage_cooldown_time=2021-05-23 00:00:00
+ p20210522: ["2021-05-22", "2021-05-23") storage_medium=SSD
storage_cooldown_time=2021-05-24 00:00:00
+ p20210523: ["2021-05-23", "2021-05-24") storage_medium=SSD
storage_cooldown_time=2021-05-25 00:00:00
+ ```
+
+- `dynamic_partition.storage_medium`
+
+
+ :::info Note
+ This parameteres is supported since Doris version 1.2.3
+ :::
+
+ Specifies the default storage medium for the created dynamic partition. HDD
is the default, SSD can be selected.
+
+ Note that when set to SSD, the `hot_partition_num` property will no longer
take effect, all partitions will default to SSD storage media and the cooldown
time will be 9999-12-31 23:59:59.
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-TABLE-PROPERTY.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-TABLE-PROPERTY.md
index c3466b10ea2..fcccb1e046f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-TABLE-PROPERTY.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-TABLE-PROPERTY.md
@@ -30,6 +30,17 @@ under the License.
ALTER TABLE PROPERTY
+:::caution
+分区属性与表属性的一些区别
+-
分区属性一般主要关注分桶数(buckets)、存储介质(storage_medium)、副本数(replication)、冷热分离存储策略(storage_policy)；
+ - 对于已经创建的分区，可以使用alter table {tableName} modify partition({partitionName})
set ({key}={value}) 来修改，但是分桶数(buckets)不能修改；
+ - 对于未创建的动态分区(dynamic partition)，可以使用alter table {tableName} set
(dynamic_partition.{key} = {value}) 来修改其属性；
+ - 对于未创建的自动分区(auto partition)，可以使用alter table {tableName} set ({key} =
{value}) 来修改其属性；
+ - 若用户想修改分区的属性，需要修改已经创建分区的属性，同时也要修改未创建分区的属性
+- 除了上面几个属性，其他均为表级别属性
+-
具体属性可以参考[建表属性](../../../../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md#properties)
+:::
+
### Description
该语句用于对已有 table 的 property 进行修改操作。这个操作是同步的，命令返回表示执行完毕。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-DATABASE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-DATABASE.md
index 32977bdf957..7da33873ffd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-DATABASE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-DATABASE.md
@@ -68,6 +68,10 @@ CREATE DATABASE [IF NOT EXISTS] db_name
);
```
+:::caution
+若建表语句属性key带replication_allocation或replication_num，则db的默认的副本分布策略不会生效
+:::
+
### Keywords
```text
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
index 77518249ff4..7615ac938a6 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
@@ -482,17 +482,7 @@ UNIQUE KEY(k1, k2)
* 动态分区相关
- 动态分区相关参数如下：
-
- * `dynamic_partition.enable`: 用于指定表级别的动态分区功能是否开启。默认为 true。
- * `dynamic_partition.time_unit:` 用于指定动态添加分区的时间单位，可选择为
DAY（天），WEEK(周)，MONTH（月），YEAR（年），HOUR（时）。
- * `dynamic_partition.start`: 用于指定向前删除多少个分区。值必须小于 0。默认为 Integer.MIN_VALUE。
- * `dynamic_partition.end`: 用于指定提前创建的分区数量。值必须大于 0。
- * `dynamic_partition.prefix`: 用于指定创建的分区名前缀，例如分区名前缀为 p，则自动创建分区名为 p20200108。
- * `dynamic_partition.buckets`: 用于指定自动创建的分区分桶数量。
- * `dynamic_partition.create_history_partition`: 是否创建历史分区。
- * `dynamic_partition.history_partition_num`: 指定创建历史分区的数量。
- * `dynamic_partition.reserved_history_periods`: 用于指定保留的历史分区的时间段。
+ 动态分区相关参考[分区分桶-动态分区](../../../../table-design/data-partition.md#动态分区)
### Example
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-partition.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-partition.md
index b0c6533d596..c1e4501be22 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-partition.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-partition.md
@@ -384,7 +384,7 @@ ERROR 5025 (HY000): Insert has filtered data in strict
mode, tracking_url=......
动态分区只支持在 DATE/DATETIME 列上进行 Range 类型的分区。
-动态分区适用于分区列的时间数据随现实世界同步增长的情况。此时可以灵活的按照与现实世界同步的时间维度对数据进行分区，自动地根据设置对数据进行冷热分层或者回收。
+动态分区适用于分区列的时间数据随现实世界同步增长的情况。此时可以灵活的按照与现实世界同步的时间维度对数据进行分区。
对于更为灵活，适用场景更多的数据入库分区，请参阅[自动分区](#自动分区)功能。
@@ -452,6 +452,10 @@ ERROR 5025 (HY000): Insert has filtered data in strict
mode, tracking_url=......
动态分区的起始偏移，为负数。根据 `time_unit`
属性的不同，以当天（星期/月）为基准，分区范围在此偏移之前的分区将会被删除。如果不填写，则默认为
`-2147483648`，即不删除历史分区。此偏移之后至当前时间的历史分区如不存在，是否创建取决于
`dynamic_partition.create_history_partition`。
+ :::caution
+ 注意，若用户设置了history_partition_num（>0），创建动态分区的起始分区就会用max(start,
-history_partition_num)，删除历史分区的时候仍然会保留到start的范围，其中start < 0。
+ :::
+
- `dynamic_partition.end`**（必选参数）**
动态分区的结束偏移，为正数。根据 `time_unit` 属性的不同，以当天（星期/月）为基准，提前创建对应范围的分区。
@@ -476,6 +480,8 @@ ERROR 5025 (HY000): Insert has filtered data in strict
mode, tracking_url=......
当 `time_unit` 为 `MONTH` 时，该参数用于指定每月的起始日期。取值为 1 到 28。其中 1 表示每月 1 号，28 表示每月 28
号。默认为 1，即表示每月以 1 号为起始点。暂不支持以 29、30、31 号为起始日，以避免因闰年或闰月带来的歧义。
+- doris支持SSD和HDD层级存储，可参考[分层存储](./tiered-storage/diff-disk-medium-migration.md)
+
- `dynamic_partition.create_history_partition`
默认为 false。当置为 true 时，Doris 会自动创建所有分区，具体创建规则见下文。同时，FE 的参数
`max_dynamic_partition_num` 会限制总分区数量，以避免一次性创建过多分区。当期望创建的分区个数大于
`max_dynamic_partition_num` 值时，操作将被禁止。
@@ -486,26 +492,6 @@ ERROR 5025 (HY000): Insert has filtered data in strict
mode, tracking_url=......
当`create_history_partition` 为 `true` 时，该参数用于指定创建历史分区数量。默认值为 -1，即未设置。**该变量与
`dynamic_partition.start` 作用相同，建议同时只设置一个。**
-- `dynamic_partition.hot_partition_num`
-
- 指定最新的多少个分区为热分区。对于热分区，系统会自动设置其 `storage_medium` 参数为 SSD，并且设置
`storage_cooldown_time`。
-
- 注意：若存储路径下没有 SSD 磁盘路径，配置该参数会导致动态分区创建失败。
-
- `hot_partition_num` 是往前 n 天和未来所有分区
-
- 我们举例说明。假设今天是 2021-05-20，按天分区，动态分区的属性设置为：hot_partition_num=2, end=3,
start=-3。则系统会自动创建以下分区，并且设置 `storage_medium` 和 `storage_cooldown_time` 参数：
-
- ```Plain
- p20210517：["2021-05-17", "2021-05-18") storage_medium=HDD
storage_cooldown_time=9999-12-31 23:59:59
- p20210518：["2021-05-18", "2021-05-19") storage_medium=HDD
storage_cooldown_time=9999-12-31 23:59:59
- p20210519：["2021-05-19", "2021-05-20") storage_medium=SSD
storage_cooldown_time=2021-05-21 00:00:00
- p20210520：["2021-05-20", "2021-05-21") storage_medium=SSD
storage_cooldown_time=2021-05-22 00:00:00
- p20210521：["2021-05-21", "2021-05-22") storage_medium=SSD
storage_cooldown_time=2021-05-23 00:00:00
- p20210522：["2021-05-22", "2021-05-23") storage_medium=SSD
storage_cooldown_time=2021-05-24 00:00:00
- p20210523：["2021-05-23", "2021-05-24") storage_medium=SSD
storage_cooldown_time=2021-05-25 00:00:00
- ```
-
- `dynamic_partition.reserved_history_periods`
需要保留的历史分区的时间范围。当`dynamic_partition.time_unit` 设置为 "DAY/WEEK/MONTH/YEAR"
时，需要以 `[yyyy-MM-dd,yyyy-MM-dd],[...,...]` 格式进行设置。当`dynamic_partition.time_unit`
设置为 "HOUR" 时，需要以 `[yyyy-MM-dd HH:mm:ss,yyyy-MM-dd HH:mm:ss],[...,...]`
的格式来进行设置。如果不设置，默认为 `"NULL"`。
@@ -533,12 +519,6 @@ ERROR 5025 (HY000): Insert has filtered data in strict
mode, tracking_url=......
这两个时间段的分区。其中，`reserved_history_periods` 的每一个 `[...,...]`
是一对设置项，两者需要同时被设置，且第一个时间不能大于第二个时间。
-- `dynamic_partition.storage_medium`
-
- 指定创建的动态分区的默认存储介质。默认是 HDD，可选择 SSD。
-
- 注意，当设置为 SSD 时，`hot_partition_num` 属性将不再生效，所有分区将默认为 SSD 存储介质并且冷却时间为
9999-12-31 23:59:59。
-
### 创建历史分区规则
当 create_history_partition 为 true，即开启创建历史分区功能时，Doris 会根据
dynamic_partition.start 和 dynamic_partition.history_partition_num 来决定创建历史分区的个数。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/overview.md
index 7c174a8b2d6..500e72c98ca 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/overview.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/overview.md
@@ -32,6 +32,11 @@ under the License.
Doris
中表名默认是大小写敏感的，可以在第一次初始化集群时配置[lower_case_table_names](../admin-manual/config/fe-config.md)为大小写不敏感的。默认的表名最大长度为
64
字节，可以通过配置[table_name_length_limit](../admin-manual/config/fe-config.md)更改，不建议配置过大。创建表的语法请参考[CREATE
TABLE](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md)。
+## 表属性
+
+Doris
的建表语句中可以指定[建表属性](../sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md#properties)，其中分桶数(buckets)、存储介质(storage_medium)、副本数(replication)、冷热分离存储策略(storage_policy)属性作用于分区，即分区创建之后，分区就会有自己的属性，修改表属性只对未来创建的分区生效，对已经创建好的分区不生效，关于属性更多的信息请参考[修改表属性](../sql-manual/sql-statements/Data-Definition-Statements/Alter/ALTER-TABLE-PROPERTY.md)
+
+
## 注意事项
1. 数据模型不可更改，因此建表时需要选择一个合适的[数据模型](../table-design/data-model/overview.md)。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/tiered-storage/diff-disk-medium-migration.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/tiered-storage/diff-disk-medium-migration.md
new file mode 100644
index 00000000000..78bb012a512
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/tiered-storage/diff-disk-medium-migration.md
@@ -0,0 +1,62 @@
+---
+{
+ "title": "SSD 和 HDD 层级存储",
+ "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.
+-->
+
+Doris支持（HDD、SSD）磁盘类型间数据根据数据冷热特性进行迁移，加速读写性能。用户可以设置分区参数将动态分区建在相应be的磁盘类型上
+
+其中dynamic_partition参数可以参考[分区分桶-动态分区](../../table-design/data-partition.md#动态分区)
+
+`dynamic_partition.hot_partition_num`
+
+:::caution
+ 注意，dynamic_partition.storage_medium必须设置为HDD，否则hot_partition_num将不会生效
+:::
+
+ 指定最新的多少个分区为热分区。对于热分区，系统会自动设置其 `storage_medium` 参数为 SSD，并且设置
`storage_cooldown_time`。
+
+ 注意：若存储路径下没有 SSD 磁盘路径，配置该参数会导致动态分区创建失败。
+
+ `hot_partition_num` 是往前 n 天和未来所有分区
+
+ 我们举例说明。假设今天是 2021-05-20，按天分区，动态分区的属性设置为：hot_partition_num=2, end=3,
start=-3。则系统会自动创建以下分区，并且设置 `storage_medium` 和 `storage_cooldown_time` 参数：
+
+ ```Plain
+ p20210517：["2021-05-17", "2021-05-18") storage_medium=HDD
storage_cooldown_time=9999-12-31 23:59:59
+ p20210518：["2021-05-18", "2021-05-19") storage_medium=HDD
storage_cooldown_time=9999-12-31 23:59:59
+ p20210519：["2021-05-19", "2021-05-20") storage_medium=SSD
storage_cooldown_time=2021-05-21 00:00:00
+ p20210520：["2021-05-20", "2021-05-21") storage_medium=SSD
storage_cooldown_time=2021-05-22 00:00:00
+ p20210521：["2021-05-21", "2021-05-22") storage_medium=SSD
storage_cooldown_time=2021-05-23 00:00:00
+ p20210522：["2021-05-22", "2021-05-23") storage_medium=SSD
storage_cooldown_time=2021-05-24 00:00:00
+ p20210523：["2021-05-23", "2021-05-24") storage_medium=SSD
storage_cooldown_time=2021-05-25 00:00:00
+ ```
+
+
+- `dynamic_partition.storage_medium`
+
+指定创建的动态分区的默认存储介质。默认是 HDD，可选择 SSD。
+
+:::caution
+ 注意，当设置为 SSD 时，`hot_partition_num` 属性将不再生效，所有分区将默认为 SSD 存储介质并且冷却时间为
9999-12-31 23:59:59。
+:::
\ No newline at end of file
diff --git a/sidebars.json b/sidebars.json
index 51f80991757..4039b9b94bb 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -84,6 +84,7 @@
"type": "category",
"label": "Tiered Storage",
"items": [
+
"table-design/tiered-storage/diff-disk-medium-migration",
"table-design/tiered-storage/remote-storage"
]
},
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
