This is an automated email from the ASF dual-hosted git repository.
luzhijing 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 5707ecd0e5 [typo](docs) modify the dynamic table document (#19750)
5707ecd0e5 is described below
commit 5707ecd0e5f7611c84a25366d13de0a2a86fccd6
Author: yuanyuan8983 <[email protected]>
AuthorDate: Thu May 18 09:24:17 2023 +0800
[typo](docs) modify the dynamic table document (#19750)
---
docs/en/docs/data-table/dynamic-schema-table.md | 18 ++++++++++++++++++
docs/zh-CN/docs/data-table/dynamic-schema-table.md | 18 ++++++++++++++++++
2 files changed, 36 insertions(+)
diff --git a/docs/en/docs/data-table/dynamic-schema-table.md
b/docs/en/docs/data-table/dynamic-schema-table.md
index 5fdd7d810e..e158164f4b 100644
--- a/docs/en/docs/data-table/dynamic-schema-table.md
+++ b/docs/en/docs/data-table/dynamic-schema-table.md
@@ -33,6 +33,10 @@ A dynamic schema table is a special kind of table which
schema expands automatic
- Static column, column specified during table creation, such as partition
columns, primary key columns
- Dynamic column, columns automatically recognized and added during import
+## Specifies the dynamic table identity
+- Method 1: By adding ... to the last column.
+- Method 2: By specifying "dynamic_schema" = "true" in properties
+
## Create dynamic table
```sql
@@ -40,6 +44,7 @@ CREATE DATABASE test_dynamic_table;
-- Create table and specify static column types, import will automatically
convert to the type of static column
-- Choose random bucketing
+-- Method 1: By ... Identifies the table as a dynamic table
CREATE TABLE IF NOT EXISTS test_dynamic_table (
qid bigint,
`answers.date` array<datetime>,
@@ -50,6 +55,19 @@ DUPLICATE KEY(`qid`)
DISTRIBUTED BY RANDOM BUCKETS 5
properties("replication_num" = "1");
+-- Method 2: By specifying "dynamic_schema" = "true" in properties
+CREATE TABLE IF NOT EXISTS test_dynamic_table (
+ qid bigint,
+ `answers.date` array<datetime>,
+ `title` string
+ )
+DUPLICATE KEY(`qid`)
+DISTRIBUTED BY RANDOM BUCKETS 5
+properties(
+ "replication_num" = "1",
+ "dynamic_schema" = "true"
+);
+
-- Three Columns are added to the table by default, and their types are
specified
mysql> DESC test_dynamic_table;
+--------------+-----------------+------+-------+---------+-------+
diff --git a/docs/zh-CN/docs/data-table/dynamic-schema-table.md
b/docs/zh-CN/docs/data-table/dynamic-schema-table.md
index 3d91d00cdf..ffb1893193 100644
--- a/docs/zh-CN/docs/data-table/dynamic-schema-table.md
+++ b/docs/zh-CN/docs/data-table/dynamic-schema-table.md
@@ -33,6 +33,10 @@ under the License.
- 静态列， 在建表时指定的列， 例如分区列、主键列
- 动态列， 随着导入自动识别并增加的列
+## 指定动态表标识
+- 方式一：通过在最后一列后加 ...
+- 方式二：通过在properties中指定 "dynamic_schema" = "true"
+
## 建表
```sql
@@ -40,6 +44,7 @@ CREATE DATABASE test_dynamic_table;
-- 建表， 并指定静态列类型， 导入遇到对应列会自动转换成静态列的类型
-- 选择随机分桶方式
+-- 方式一：通过...标识该表是动态表
CREATE TABLE IF NOT EXISTS test_dynamic_table (
qid bigint,
`answers.date` array<datetime>,
@@ -50,6 +55,19 @@ DUPLICATE KEY(`qid`)
DISTRIBUTED BY RANDOM BUCKETS 5
properties("replication_num" = "1");
+-- 方式二：通过在properties中指定 "dynamic_schema" = "true"
+CREATE TABLE IF NOT EXISTS test_dynamic_table (
+ qid bigint,
+ `answers.date` array<datetime>,
+ `title` string
+ )
+DUPLICATE KEY(`qid`)
+DISTRIBUTED BY RANDOM BUCKETS 5
+properties(
+ "replication_num" = "1",
+ "dynamic_schema" = "true"
+);
+
-- 可以看到三列Column在表中默认添加， 类型是指定类型
mysql> DESC test_dynamic_table;
+--------------+-----------------+------+-------+---------+-------+
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
