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 <zhang...@gmail.com> 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: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org