You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by da...@apache.org on 2022/07/18 07:25:58 UTC
[doris] branch master updated: [doc] Add compression properties to the create table document (#10829)
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.git
The following commit(s) were added to refs/heads/master by this push:
new 16866e3c55 [doc] Add compression properties to the create table document (#10829)
16866e3c55 is described below
commit 16866e3c55cee0fc1369a299715c00618bd5b9de
Author: Hong Liu <84...@qq.com>
AuthorDate: Mon Jul 18 15:25:53 2022 +0800
[doc] Add compression properties to the create table document (#10829)
Co-authored-by: smallhibiscus <844981280>
---
.../Create/CREATE-TABLE.md | 17 ++++++++++++-----
.../Create/CREATE-TABLE.md | 20 +++++++++++++-------
2 files changed, 25 insertions(+), 12 deletions(-)
diff --git a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
index a85c2cb947..f8d086d49c 100644
--- a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
+++ b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
@@ -306,8 +306,14 @@ distribution_info
`"function_column.sequence_type" ='Date'`
- * Dynamic partition related
+ * `compression`
+ The default compression method for Doris tables is LZ4. After version 1.1, it is supported to specify the compression method as ZSTD to obtain a higher compression ratio.
+
+ `"compression"="zstd"`
+
+ * 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.
@@ -321,12 +327,11 @@ distribution_info
* `dynamic_partition.reserved_history_periods`: Used to specify the range of reserved history periods.
* Data Sort Info
-
+
The relevant parameters of data sort info are as follows:
-
+
* `data_sort.sort_type`: the method of data sorting, options: z-order/lexical, default is lexical
* `data_sort.col_num`: the first few columns to sort, col_num muster less than total key counts
-
### Example
1. Create a detailed model table
@@ -529,7 +534,8 @@ distribution_info
PROPERTIES (
"replication_allocation"="tag.location.group_a:1, tag.location.group_b:2"
);
-
+ ```
+ ```sql
CREATE TABLE example_db.dynamic_partition
(
k1 DATE,
@@ -548,6 +554,7 @@ distribution_info
"dynamic_partition.buckets" = "32",
"dynamic_partition."replication_allocation" = "tag.location.group_a:3"
);
+ ```
### Keywords
diff --git a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
index 580977625f..2a29932ce2 100644
--- a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
+++ b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
@@ -299,16 +299,22 @@ distribution_info
`"in_memory" = "true"`
+ * `compression`
+
+ Doris 表的默认压缩方式是 LZ4。1.1版本后,支持将压缩方式指定为ZSTD以获得更高的压缩比。
+
+ `"compression"="zstd"`
+
* `function_column.sequence_type`
当使用 UNIQUE KEY 模型时,可以指定一个sequence列,当KEY列相同时,将按照 sequence 列进行 REPLACE(较大值替换较小值,否则无法替换)
这里我们仅需指定顺序列的类型,支持时间类型或整型。Doris 会创建一个隐藏的顺序列。
-
+
`"function_column.sequence_type" = 'Date'`
-
+
* 动态分区相关
-
+
动态分区相关参数如下:
* `dynamic_partition.enable`: 用于指定表级别的动态分区功能是否开启。默认为 true。
@@ -320,9 +326,9 @@ distribution_info
* `dynamic_partition.create_history_partition`: 是否创建历史分区。
* `dynamic_partition.history_partition_num`: 指定创建历史分区的数量。
* `dynamic_partition.reserved_history_periods`: 用于指定保留的历史分区的时间段。
-
+
* 数据排序相关
-
+
数据排序相关参数如下:
* `data_sort.sort_type`: 数据排序使用的方法,目前支持两种:lexical/z-order,默认是lexical
@@ -529,8 +535,8 @@ distribution_info
PROPERTIES (
"replication_allocation"="tag.location.group_a:1, tag.location.group_b:2"
);
-
-
+ ```
+ ```sql
CREATE TABLE example_db.dynamic_partition
(
k1 DATE,
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org