You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by ji...@apache.org on 2022/07/21 10:13:07 UTC
[doris-website] branch master updated: fix stream load doc
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 dd34a72fc0 fix stream load doc
new aa8dff6a93 Merge branch 'master' of https://github.com/apache/doris-website
dd34a72fc0 is described below
commit dd34a72fc0b5eee3a262c396dc57b09989d52e61
Author: jiafeng.zhang <zh...@gmail.com>
AuthorDate: Thu Jul 21 18:12:22 2022 +0800
fix stream load doc
fix stream load doc
---
.../import/import-way/stream-load-manual.md | 8 +++++++-
.../Show-Statements/SHOW-STREAM-LOAD.md | 1 +
.../import/import-way/stream-load-manual.md | 8 +++++++-
.../sql-reference/Show-Statements/SHOW-LOAD.md | 22 ++++++++++++----------
4 files changed, 27 insertions(+), 12 deletions(-)
diff --git a/docs/data-operate/import/import-way/stream-load-manual.md b/docs/data-operate/import/import-way/stream-load-manual.md
index a1e8eb9e74..0b0a67913b 100644
--- a/docs/data-operate/import/import-way/stream-load-manual.md
+++ b/docs/data-operate/import/import-way/stream-load-manual.md
@@ -216,7 +216,7 @@ The number of rows in the original file = `dpp.abnorm.ALL + dpp.norm.ALL`
"status": "Success",
"msg": "transaction [18037] abort successfully."
}
- ```
+ ```
### Return results
@@ -298,6 +298,12 @@ The following main explanations are given for the Stream load import result para
Users can't cancel Stream load manually. Stream load will be cancelled automatically by the system after a timeout or import error.
+### View Stream Load
+
+Users can view completed stream load tasks through `show stream load`.
+
+By default, BE does not record Stream Load records. If you want to view the records that need to be enabled on BE `enable_stream_load_record=true`, you need to restart BE here
+
## Relevant System Configuration
### FE configuration
diff --git a/docs/sql-manual/sql-reference/Show-Statements/SHOW-STREAM-LOAD.md b/docs/sql-manual/sql-reference/Show-Statements/SHOW-STREAM-LOAD.md
index 46d1a8b015..3ac7ba14ee 100644
--- a/docs/sql-manual/sql-reference/Show-Statements/SHOW-STREAM-LOAD.md
+++ b/docs/sql-manual/sql-reference/Show-Statements/SHOW-STREAM-LOAD.md
@@ -50,6 +50,7 @@ SHOW STREAM LOAD
illustrate:
+1. The default is to not record Stream Load records. If you want to view the records that need to be enabled on BE, `enable_stream_load_record=true`, you need to restart BE here
1. If db_name is not specified, the current default db is used
2. If LABEL LIKE is used, it will match the tasks whose label of the Stream Load task contains label_matcher
3. If LABEL = is used, it will match the specified label exactly
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/import-way/stream-load-manual.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/import-way/stream-load-manual.md
index efc21985d0..606ca5f2a2 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/import-way/stream-load-manual.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/import-way/stream-load-manual.md
@@ -227,7 +227,7 @@ Stream Load 由于使用的是 HTTP 协议，所以所有导入任务有关的
"status": "Success",
"msg": "transaction [18037] abort successfully."
}
- ```
+ ```
### 返回结果
@@ -310,6 +310,12 @@ Stream Load 由于使用的是 HTTP 协议，所以所有导入任务有关的
用户无法手动取消 Stream Load，Stream Load 在超时或者导入错误后会被系统自动取消。
+### 查看 Stream Load
+
+用户可以通过 `show stream load` 来查看已经完成的 stream load 任务。
+
+默认 BE 是不记录 Stream Load 的记录，如果你要查看需要再 BE 上启用记录，`enable_stream_load_record=true`，这里需要重启BE
+
## 相关系统配置
### FE配置
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Show-Statements/SHOW-LOAD.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Show-Statements/SHOW-LOAD.md
index 0cbbf581be..a58a99369e 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Show-Statements/SHOW-LOAD.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Show-Statements/SHOW-LOAD.md
@@ -50,20 +50,22 @@ SHOW LOAD
说明：
+1) 默认是不记录 Stream Load 的记录，如果你要查看需要再 BE 上启用记录，`enable_stream_load_record=true`，这里需要重启 BE
+
1) 如果不指定 db_name，使用当前默认db
-
+
2) 如果使用 LABEL LIKE，则会匹配导入任务的 label 包含 label_matcher 的导入任务
3) 如果使用 LABEL = ，则精确匹配指定的 label
4) 如果指定了 STATE，则匹配 LOAD 状态
-
+
5) 可以使用 ORDER BY 对任意列组合进行排序
-
+
6) 如果指定了 LIMIT，则显示 limit 条匹配记录。否则全部显示
7) 如果指定了 OFFSET，则从偏移量offset开始显示查询结果。默认情况下偏移量为0。
-
+
8) 如果是使用 broker/mini load，则 URL 列中的连接可以使用以下命令查看：
```sql
@@ -73,38 +75,38 @@ SHOW LOAD
### Example
1. 展示默认 db 的所有导入任务
-
+
```sql
SHOW LOAD;
```
2. 展示指定 db 的导入任务，label 中包含字符串 "2014_01_02"，展示最老的10个
-
+
```sql
SHOW LOAD FROM example_db WHERE LABEL LIKE "2014_01_02" LIMIT 10;
```
3. 展示指定 db 的导入任务，指定 label 为 "load_example_db_20140102" 并按 LoadStartTime 降序排序
-
+
```sql
SHOW LOAD FROM example_db WHERE LABEL = "load_example_db_20140102" ORDER BY LoadStartTime DESC;
```
4. 展示指定 db 的导入任务，指定 label 为 "load_example_db_20140102" ，state 为 "loading", 并按 LoadStartTime 降序排序
-
+
```sql
SHOW LOAD FROM example_db WHERE LABEL = "load_example_db_20140102" AND STATE = "loading" ORDER BY LoadStartTime DESC;
```
5. 展示指定 db 的导入任务 并按 LoadStartTime 降序排序,并从偏移量5开始显示10条查询结果
-
+
```sql
SHOW LOAD FROM example_db ORDER BY LoadStartTime DESC limit 5,10;
SHOW LOAD FROM example_db ORDER BY LoadStartTime DESC limit 10 offset 5;
```
6. 小批量导入是查看导入状态的命令
-
+
```
curl --location-trusted -u {user}:{passwd} http://{hostname}:{port}/api/{database}/_load_info?label={labelname}
```
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org