This is an automated email from the ASF dual-hosted git repository.
liaoxin 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 b1b36f0e314 [doc](load) fix some typo for data transform (#1676)
b1b36f0e314 is described below
commit b1b36f0e314f6d59bc66d70d71bbad42292e9c29
Author: Xin Liao <[email protected]>
AuthorDate: Mon Dec 30 19:13:59 2024 +0800
[doc](load) fix some typo for data transform (#1676)
---
docs/data-operate/import/load-data-convert.md | 26 +++++++++++-----------
.../data-operate/import/load-data-convert.md | 26 +++++++++++-----------
.../data-operate/import/load-data-convert.md | 26 +++++++++++-----------
.../data-operate/import/load-data-convert.md | 26 +++++++++++-----------
.../data-operate/import/load-data-convert.md | 26 +++++++++++-----------
.../data-operate/import/load-data-convert.md | 26 +++++++++++-----------
6 files changed, 78 insertions(+), 78 deletions(-)
diff --git a/docs/data-operate/import/load-data-convert.md
b/docs/data-operate/import/load-data-convert.md
index 3319f75a423..dee8d02b3e9 100644
--- a/docs/data-operate/import/load-data-convert.md
+++ b/docs/data-operate/import/load-data-convert.md
@@ -181,7 +181,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -261,7 +261,7 @@ FROM KAFKA (...);
The third column of the source file is named tmp_skip, which is a custom
column name that does not exist in the table. It is ignored during loading and
not written to the target table.
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -346,7 +346,7 @@ Note:
- If it is a nullable column, it will be filled with NULL.
- If it is a non-nullable column without a default value, the load will fail.
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -437,7 +437,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -512,7 +512,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -526,7 +526,7 @@ mysql> select * from example_table;
+------+------+------+------+
```
-### Handling NULL Values in Source Files
+#### Handling NULL Values in Source Files
Suppose the target table has four columns: k1, k2, k3, and k4. We want to
transform the column values as follows:
@@ -535,7 +535,7 @@ Suppose the target table has four columns: k1, k2, k3, and
k4. We want to transf
- Column3 -> k3
- Column4 -> k4
-#### Creating the Target Table
+##### Creating the Target Table
```sql
CREATE TABLE example_table
@@ -550,7 +550,7 @@ DUPLICATE KEY(k1)
DISTRIBUTED BY HASH(k1) BUCKETS 1;
```
-#### Loading Data
+##### Loading Data
- Stream Load
@@ -588,7 +588,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -752,7 +752,7 @@ WHERE k4 > 1.2;
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -764,7 +764,7 @@ mysql> select * from example_table;
+------+------+-----------+------+
```
-##### Filtering After Column Transformation
+#### Filtering After Column Transformation
Suppose the target table has four columns: k1, k2, k3, and k4. We want to
transform Column3 to area ID and filter out rows where the area ID is 3.
@@ -826,7 +826,7 @@ WHERE k3 != 3;
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -895,7 +895,7 @@ WHERE k1 is not null and k4 > 1.2
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/load-data-convert.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/load-data-convert.md
index b207f58f036..6f82f60d6e3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/load-data-convert.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/load-data-convert.md
@@ -173,7 +173,7 @@ COLUMNS(k1, k3, k2, k4),
COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+-----------+------+------+
@@ -244,7 +244,7 @@ FROM KAFKA (...);
源文件的第三列被命名为 tmp_skip，tmp_skip 为一个自定义的、表中不存在的列名，在导入过程中被忽略，不会写入目标表。
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+------+
@@ -320,7 +320,7 @@ FROM KAFKA (...);
- 如果是可空列（nullable），将填充 NULL 值
- 如果是非空列且没有默认值，导入会失败
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+-----------+------+------+------+
@@ -403,7 +403,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+-----------+-------+------+
@@ -470,7 +470,7 @@ COLUMNS(k1, k2, tmp_k3, k4, k3 = CASE tmp_k3 WHEN 'beijing'
THEN 1 WHEN 'shangha
COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+------+------+
@@ -483,7 +483,7 @@ mysql> select * from example_table;
+------+------+------+------+
```
-### 源文件中的 NULL 值处理
+#### 源文件中的 NULL 值处理
假设表中有 k1,k2,k3,k4 4 列。在对地区 id 转换的同时，我们也希望对于源数据中 k1 列的 null 值转换成 0 导入：
@@ -492,7 +492,7 @@ mysql> select * from example_table;
列3 -> k3
列4 -> k4
-#### 创建示例表
+##### 创建示例表
```sql
CREATE TABLE example_table
(
@@ -506,7 +506,7 @@ DUPLICATE KEY(k1)
DISTRIBUTED BY HASH(k1) BUCKETS 1;
```
-#### 导入数据
+##### 导入数据
- Stream Load
```sql
curl --location-trusted -u user:passwd \
@@ -539,7 +539,7 @@ COLUMNS(k1, tmp_k2, tmp_k3, k4, k2 = ifnull(tmp_k2, 0), k3
= CASE tmp_k3 WHEN 'b
COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+------+------+
@@ -693,7 +693,7 @@ WHERE k4 > 1.2;
FROM KAFKA (...)
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+-----------+------+
@@ -704,7 +704,7 @@ mysql> select * from example_table;
+------+------+-----------+------+
```
-##### 对经过列转换的数据进行过滤
+#### 对经过列转换的数据进行过滤
假设表中有 k1,k2,k3,k4 4 列。在列转换示例中，我们将省份名称转换成了 id。这里我们想过滤掉 id 为 3 的数据。
##### 创建示例表
@@ -760,7 +760,7 @@ WHERE k3 != 3;
FROM KAFKA (...)
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+------+------+
@@ -822,7 +822,7 @@ WHERE k1 is not null and k4 > 1.2
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+-----------+------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/import/load-data-convert.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/import/load-data-convert.md
index b207f58f036..6f82f60d6e3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/import/load-data-convert.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/import/load-data-convert.md
@@ -173,7 +173,7 @@ COLUMNS(k1, k3, k2, k4),
COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+-----------+------+------+
@@ -244,7 +244,7 @@ FROM KAFKA (...);
源文件的第三列被命名为 tmp_skip，tmp_skip 为一个自定义的、表中不存在的列名，在导入过程中被忽略，不会写入目标表。
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+------+
@@ -320,7 +320,7 @@ FROM KAFKA (...);
- 如果是可空列（nullable），将填充 NULL 值
- 如果是非空列且没有默认值，导入会失败
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+-----------+------+------+------+
@@ -403,7 +403,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+-----------+-------+------+
@@ -470,7 +470,7 @@ COLUMNS(k1, k2, tmp_k3, k4, k3 = CASE tmp_k3 WHEN 'beijing'
THEN 1 WHEN 'shangha
COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+------+------+
@@ -483,7 +483,7 @@ mysql> select * from example_table;
+------+------+------+------+
```
-### 源文件中的 NULL 值处理
+#### 源文件中的 NULL 值处理
假设表中有 k1,k2,k3,k4 4 列。在对地区 id 转换的同时，我们也希望对于源数据中 k1 列的 null 值转换成 0 导入：
@@ -492,7 +492,7 @@ mysql> select * from example_table;
列3 -> k3
列4 -> k4
-#### 创建示例表
+##### 创建示例表
```sql
CREATE TABLE example_table
(
@@ -506,7 +506,7 @@ DUPLICATE KEY(k1)
DISTRIBUTED BY HASH(k1) BUCKETS 1;
```
-#### 导入数据
+##### 导入数据
- Stream Load
```sql
curl --location-trusted -u user:passwd \
@@ -539,7 +539,7 @@ COLUMNS(k1, tmp_k2, tmp_k3, k4, k2 = ifnull(tmp_k2, 0), k3
= CASE tmp_k3 WHEN 'b
COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+------+------+
@@ -693,7 +693,7 @@ WHERE k4 > 1.2;
FROM KAFKA (...)
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+-----------+------+
@@ -704,7 +704,7 @@ mysql> select * from example_table;
+------+------+-----------+------+
```
-##### 对经过列转换的数据进行过滤
+#### 对经过列转换的数据进行过滤
假设表中有 k1,k2,k3,k4 4 列。在列转换示例中，我们将省份名称转换成了 id。这里我们想过滤掉 id 为 3 的数据。
##### 创建示例表
@@ -760,7 +760,7 @@ WHERE k3 != 3;
FROM KAFKA (...)
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+------+------+
@@ -822,7 +822,7 @@ WHERE k1 is not null and k4 > 1.2
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+-----------+------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/import/load-data-convert.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/import/load-data-convert.md
index b207f58f036..6f82f60d6e3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/import/load-data-convert.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/import/load-data-convert.md
@@ -173,7 +173,7 @@ COLUMNS(k1, k3, k2, k4),
COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+-----------+------+------+
@@ -244,7 +244,7 @@ FROM KAFKA (...);
源文件的第三列被命名为 tmp_skip，tmp_skip 为一个自定义的、表中不存在的列名，在导入过程中被忽略，不会写入目标表。
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+------+
@@ -320,7 +320,7 @@ FROM KAFKA (...);
- 如果是可空列（nullable），将填充 NULL 值
- 如果是非空列且没有默认值，导入会失败
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+-----------+------+------+------+
@@ -403,7 +403,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+-----------+-------+------+
@@ -470,7 +470,7 @@ COLUMNS(k1, k2, tmp_k3, k4, k3 = CASE tmp_k3 WHEN 'beijing'
THEN 1 WHEN 'shangha
COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+------+------+
@@ -483,7 +483,7 @@ mysql> select * from example_table;
+------+------+------+------+
```
-### 源文件中的 NULL 值处理
+#### 源文件中的 NULL 值处理
假设表中有 k1,k2,k3,k4 4 列。在对地区 id 转换的同时，我们也希望对于源数据中 k1 列的 null 值转换成 0 导入：
@@ -492,7 +492,7 @@ mysql> select * from example_table;
列3 -> k3
列4 -> k4
-#### 创建示例表
+##### 创建示例表
```sql
CREATE TABLE example_table
(
@@ -506,7 +506,7 @@ DUPLICATE KEY(k1)
DISTRIBUTED BY HASH(k1) BUCKETS 1;
```
-#### 导入数据
+##### 导入数据
- Stream Load
```sql
curl --location-trusted -u user:passwd \
@@ -539,7 +539,7 @@ COLUMNS(k1, tmp_k2, tmp_k3, k4, k2 = ifnull(tmp_k2, 0), k3
= CASE tmp_k3 WHEN 'b
COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+------+------+
@@ -693,7 +693,7 @@ WHERE k4 > 1.2;
FROM KAFKA (...)
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+-----------+------+
@@ -704,7 +704,7 @@ mysql> select * from example_table;
+------+------+-----------+------+
```
-##### 对经过列转换的数据进行过滤
+#### 对经过列转换的数据进行过滤
假设表中有 k1,k2,k3,k4 4 列。在列转换示例中，我们将省份名称转换成了 id。这里我们想过滤掉 id 为 3 的数据。
##### 创建示例表
@@ -760,7 +760,7 @@ WHERE k3 != 3;
FROM KAFKA (...)
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+------+------+
@@ -822,7 +822,7 @@ WHERE k1 is not null and k4 > 1.2
FROM KAFKA (...);
```
-#### 查询结果
+##### 查询结果
```
mysql> select * from example_table;
+------+------+-----------+------+
diff --git
a/versioned_docs/version-2.1/data-operate/import/load-data-convert.md
b/versioned_docs/version-2.1/data-operate/import/load-data-convert.md
index 3319f75a423..dee8d02b3e9 100644
--- a/versioned_docs/version-2.1/data-operate/import/load-data-convert.md
+++ b/versioned_docs/version-2.1/data-operate/import/load-data-convert.md
@@ -181,7 +181,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -261,7 +261,7 @@ FROM KAFKA (...);
The third column of the source file is named tmp_skip, which is a custom
column name that does not exist in the table. It is ignored during loading and
not written to the target table.
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -346,7 +346,7 @@ Note:
- If it is a nullable column, it will be filled with NULL.
- If it is a non-nullable column without a default value, the load will fail.
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -437,7 +437,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -512,7 +512,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -526,7 +526,7 @@ mysql> select * from example_table;
+------+------+------+------+
```
-### Handling NULL Values in Source Files
+#### Handling NULL Values in Source Files
Suppose the target table has four columns: k1, k2, k3, and k4. We want to
transform the column values as follows:
@@ -535,7 +535,7 @@ Suppose the target table has four columns: k1, k2, k3, and
k4. We want to transf
- Column3 -> k3
- Column4 -> k4
-#### Creating the Target Table
+##### Creating the Target Table
```sql
CREATE TABLE example_table
@@ -550,7 +550,7 @@ DUPLICATE KEY(k1)
DISTRIBUTED BY HASH(k1) BUCKETS 1;
```
-#### Loading Data
+##### Loading Data
- Stream Load
@@ -588,7 +588,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -752,7 +752,7 @@ WHERE k4 > 1.2;
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -764,7 +764,7 @@ mysql> select * from example_table;
+------+------+-----------+------+
```
-##### Filtering After Column Transformation
+#### Filtering After Column Transformation
Suppose the target table has four columns: k1, k2, k3, and k4. We want to
transform Column3 to area ID and filter out rows where the area ID is 3.
@@ -826,7 +826,7 @@ WHERE k3 != 3;
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -895,7 +895,7 @@ WHERE k1 is not null and k4 > 1.2
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
diff --git
a/versioned_docs/version-3.0/data-operate/import/load-data-convert.md
b/versioned_docs/version-3.0/data-operate/import/load-data-convert.md
index 3319f75a423..dee8d02b3e9 100644
--- a/versioned_docs/version-3.0/data-operate/import/load-data-convert.md
+++ b/versioned_docs/version-3.0/data-operate/import/load-data-convert.md
@@ -181,7 +181,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -261,7 +261,7 @@ FROM KAFKA (...);
The third column of the source file is named tmp_skip, which is a custom
column name that does not exist in the table. It is ignored during loading and
not written to the target table.
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -346,7 +346,7 @@ Note:
- If it is a nullable column, it will be filled with NULL.
- If it is a non-nullable column without a default value, the load will fail.
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -437,7 +437,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -512,7 +512,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -526,7 +526,7 @@ mysql> select * from example_table;
+------+------+------+------+
```
-### Handling NULL Values in Source Files
+#### Handling NULL Values in Source Files
Suppose the target table has four columns: k1, k2, k3, and k4. We want to
transform the column values as follows:
@@ -535,7 +535,7 @@ Suppose the target table has four columns: k1, k2, k3, and
k4. We want to transf
- Column3 -> k3
- Column4 -> k4
-#### Creating the Target Table
+##### Creating the Target Table
```sql
CREATE TABLE example_table
@@ -550,7 +550,7 @@ DUPLICATE KEY(k1)
DISTRIBUTED BY HASH(k1) BUCKETS 1;
```
-#### Loading Data
+##### Loading Data
- Stream Load
@@ -588,7 +588,7 @@ COLUMNS TERMINATED BY ","
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -752,7 +752,7 @@ WHERE k4 > 1.2;
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -764,7 +764,7 @@ mysql> select * from example_table;
+------+------+-----------+------+
```
-##### Filtering After Column Transformation
+#### Filtering After Column Transformation
Suppose the target table has four columns: k1, k2, k3, and k4. We want to
transform Column3 to area ID and filter out rows where the area ID is 3.
@@ -826,7 +826,7 @@ WHERE k3 != 3;
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
@@ -895,7 +895,7 @@ WHERE k1 is not null and k4 > 1.2
FROM KAFKA (...);
```
-#### Query Results
+##### Query Results
```
mysql> select * from example_table;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
