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 53ca9c12978 fix
53ca9c12978 is described below
commit 53ca9c12978f474ecaab1618d16fe675208fe5a9
Author: jiafeng.zhang <[email protected]>
AuthorDate: Sun Oct 23 10:49:36 2022 +0800
fix
---
.../Create/CREATE-POLICY.md | 24 ----------------------
.../Create/CREATE-POLICY.md | 22 --------------------
2 files changed, 46 deletions(-)
diff --git
a/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-POLICY.md
b/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-POLICY.md
index 73e7b240c7d..616333f4194 100644
---
a/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-POLICY.md
+++
b/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-POLICY.md
@@ -59,12 +59,6 @@ PROPERTIES ("key"="value", ...);
illustrate：
- PROPERTIES has such keys:
1. storage_resource：storage resource name for policy
- 2. cooldown_datetime：cool down time for tablet, can't be set with
cooldown_ttl.
- 3. cooldown_ttl：hot data stay time. The time cost between the time of
tablet created and
- the time of migrated to cold data, formatted as：
- 1d：1 day
- 1h：1 hour
- 50000: 50000 second
### Example
@@ -93,24 +87,6 @@ illustrate：
select * from (select * from table1 where c1 = 'a' and c2 = 'b' or c3 = 'c'
or c4 = 'd')
```
-2. Create policy for storage
- 1. Create policy on cooldown_datetime
- ```sql
- CREATE STORAGE POLICY testPolicy
- PROPERTIES(
- "storage_resource" = "s3",
- "cooldown_datetime" = "2022-06-08 00:00:00"
- );
- ```
- 2. Create policy on cooldown_ttl
- ```sql
- CREATE STORAGE POLICY testPolicy
- PROPERTIES(
- "storage_resource" = "s3",
- "cooldown_ttl" = "1d"
- );
- ```
-
### Keywords
CREATE, POLICY
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-POLICY.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-POLICY.md
index b3b9c7f041b..e90bf42398f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-POLICY.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-POLICY.md
@@ -59,11 +59,6 @@ PROPERTIES ("key"="value", ...);
参数说明：
- PROPERTIES中需要指定资源的类型:
1. storage_resource：指定策略使用的storage resource名称。
- 2. cooldown_datetime：热数据转为冷数据时间，不能与cooldown_ttl同时存在。
- 3. cooldown_ttl：热数据持续时间。从数据分片生成时开始计算，经过指定时间后转为冷数据。支持的格式：
- 1d：1天
- 1h：1小时
- 50000: 50000秒
### Example
@@ -91,23 +86,6 @@ PROPERTIES ("key"="value", ...);
```sql
select * from (select * from table1 where c1 = 'a' and c2 = 'b' or c3 = 'c'
or c4 = 'd')
```
-2. 创建数据迁移策略
- 1. 指定数据冷却时间创建数据迁移策略
- ```sql
- CREATE STORAGE POLICY testPolicy
- PROPERTIES(
- "storage_resource" = "s3",
- "cooldown_datetime" = "2022-06-08 00:00:00"
- );
- ```
- 2. 指定热数据持续时间创建数据迁移策略
- ```sql
- CREATE STORAGE POLICY testPolicy
- PROPERTIES(
- "storage_resource" = "s3",
- "cooldown_ttl" = "1d"
- );
- ```
### Keywords
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
