This is an automated email from the ASF dual-hosted git repository.
morningman 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 3887bc95329 [opt](export) opt the doc of export to local (#1766)
3887bc95329 is described below
commit 3887bc9532946bf5033a69d3382b82ad4aafe5fc
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Mon Jan 13 09:46:40 2025 +0800
[opt](export) opt the doc of export to local (#1766)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/data-operate/export/export-manual.md | 33 ++++++++++++++++++++--
docs/data-operate/export/outfile.md | 24 ++++++++++++++--
.../current/data-operate/export/export-manual.md | 33 ++++++++++++++++++++--
.../current/data-operate/export/outfile.md | 23 +++++++++++++--
.../data-operate/export/export-manual.md | 33 ++++++++++++++++++++--
.../version-2.1/data-operate/export/outfile.md | 23 +++++++++++++--
.../data-operate/export/export-manual.md | 33 ++++++++++++++++++++--
.../version-3.0/data-operate/export/outfile.md | 23 +++++++++++++--
.../data-operate/export/export-manual.md | 33 ++++++++++++++++++++--
.../version-2.1/data-operate/export/outfile.md | 24 ++++++++++++++--
.../data-operate/export/export-manual.md | 33 ++++++++++++++++++++--
.../version-3.0/data-operate/export/outfile.md | 24 ++++++++++++++--
12 files changed, 303 insertions(+), 36 deletions(-)
diff --git a/docs/data-operate/export/export-manual.md
b/docs/data-operate/export/export-manual.md
index 47d21121e69..c493079e86f 100644
--- a/docs/data-operate/export/export-manual.md
+++ b/docs/data-operate/export/export-manual.md
@@ -125,7 +125,7 @@ OutfileInfo: [
{
"fileNumber": "1",
"totalRows": "6001215",
- "fileSize": "747503989bytes",
+ "fileSize": "747503989",
"url": "s3://bucket/export/export_6555cd33e7447c1-baa9568b5c4eb0ac_*"
}
]
@@ -363,13 +363,40 @@ If you want to enable this function, please add
`enable_outfile_to_local=true` i
Example: Export all the data in the `tbl` table to the local file system, set
the file format of the export job to csv (the default format), and set the
column delimiter to `,`.
```sql
-EXPORT TABLE tbl TO "file:///home/user/tmp/"
+EXPORT TABLE tbl TO "file:///path/to/result_"
PROPERTIES (
"format" = "csv",
"line_delimiter" = ","
);
```
+This function will export and write data to the disk of the node where the BE
is located. If there are multiple BE nodes, the data will be scattered on
different BE nodes according to the concurrency of the export task, and each
node will have a part of the data.
+
+As in this example, a set of files similar to
`result_7052bac522d840f5-972079771289e392_0.csv` will eventually be produced
under `/path/to/` of the BE node.
+
+The specific BE node IP can be viewed in the `OutfileInfo` column in the `SHOW
EXPORT` result, such as:
+
+```
+[
+ [
+ {
+ "fileNumber": "1",
+ "totalRows": "0",
+ "fileSize": "8388608",
+ "url":
"file:///172.20.32.136/path/to/result_7052bac522d840f5-972079771289e392_*"
+ }
+ ],
+ [
+ {
+ "fileNumber": "1",
+ "totalRows": "0",
+ "fileSize": "8388608",
+ "url":
"file:///172.20.32.137/path/to/result_22aba7ec933b4922-ba81e5eca12bf0c2_*"
+ }
+ ]
+]
+```
+
:::caution
-This function will export and write the data to the disks of the nodes where
the BE is located. If there are multiple BE nodes, the data will be distributed
across different BE nodes according to the concurrency of the export tasks, and
each node will have a portion of the data. This function is not applicable to
the production environment, and please ensure the permissions of the export
directory and data security on your own.
+This function is not applicable to the production environment, and please
ensure the permissions of the export directory and data security on your own.
:::
diff --git a/docs/data-operate/export/outfile.md
b/docs/data-operate/export/outfile.md
index 60dd21735d8..29565371bb0 100644
--- a/docs/data-operate/export/outfile.md
+++ b/docs/data-operate/export/outfile.md
@@ -268,7 +268,7 @@ If you want to enable this function, please add
`enable_outfile_to_local=true` i
Example: Export all the data in the tbl table to the local file system, set
the file format of the export job to csv (the default format), and set the
column separator to `,`.
```sql
-SELECT c1, c2 FROM tbl FROM tbl1
+SELECT c1, c2 FROM db.tbl
INTO OUTFILE "file:///path/to/result_"
FORMAT AS CSV
PROPERTIES(
@@ -276,6 +276,24 @@ PROPERTIES(
);
```
+This function will export and write data to the disk of the node where the BE
is located. If there are multiple BE nodes, the data will be scattered on
different BE nodes according to the concurrency of the export task, and each
node will have a part of the data.
+
+As in this example, a set of files similar to
`result_c6df5f01bd664dde-a2168b019b6c2b3f_0.csv` will eventually be produced
under `/path/to/` of the BE node.
+
+The specific BE node IP will be displayed in the returned results, such as:
+
+```
++------------+-----------+----------+--------------------------------------------------------------------------+
+| FileNumber | TotalRows | FileSize | URL
|
++------------+-----------+----------+--------------------------------------------------------------------------+
+| 1 | 1195072 | 4780288 |
file:///172.20.32.136/path/to/result_c6df5f01bd664dde-a2168b019b6c2b3f_* |
+| 1 | 1202944 | 4811776 |
file:///172.20.32.136/path/to/result_c6df5f01bd664dde-a2168b019b6c2b40_* |
+| 1 | 1198880 | 4795520 |
file:///172.20.32.137/path/to/result_c6df5f01bd664dde-a2168b019b6c2b43_* |
+| 1 | 1198880 | 4795520 |
file:///172.20.32.137/path/to/result_c6df5f01bd664dde-a2168b019b6c2b45_* |
++------------+-----------+----------+--------------------------------------------------------------------------+
+```
+
:::caution
-This function will export and write data to the disks of the nodes where the
BE is located. If there are multiple BE nodes, the data will be scattered among
different BE nodes according to the concurrency of the export tasks, and each
node will have a part of the data. This function is not suitable for the
production environment, and please ensure the permissions and data security of
the export directory on your own.
-:::
\ No newline at end of file
+This function is not suitable for the production environment, and please
ensure the permissions and data security of the export directory on your own.
+:::
+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/export/export-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/export/export-manual.md
index 5502719067b..8c82a38cf65 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/export/export-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/export/export-manual.md
@@ -124,7 +124,7 @@ OutfileInfo: [
{
"fileNumber": "1",
"totalRows": "6001215",
- "fileSize": "747503989bytes",
+ "fileSize": "747503989",
"url": "s3://bucket/export/export_6555cd33e7447c1-baa9568b5c4eb0ac_*"
}
]
@@ -362,14 +362,41 @@ Export 任务的底层是执行`SELECT INTO OUTFILE` SQL 语句。用户发起
示例：将 tbl 表中的所有数据导出到本地文件系统，设置导出作业的文件格式为 csv（默认格式），并设置列分割符为`,`。
```sql
-EXPORT TABLE tbl TO "file:///home/user/tmp/"
+EXPORT TABLE db.tbl TO "file:///path/to/result_"
PROPERTIES (
"format" = "csv",
"line_delimiter" = ","
);
```
+此功能会将数据导出并写入到 BE 所在节点的磁盘上，如果有多个 BE 节点，则数据会根据导出任务的并发度分散在不同 BE 节点上，每个节点有一部分数据。
+
+如在这个示例中，最终会在 BE 节点的 `/path/to/` 下生产一组类似
`result_7052bac522d840f5-972079771289e392_0.csv` 的文件。
+
+具体的 BE 节点 IP 可以在 `SHOW EXPORT` 结果中的 `OutfileInfo` 列查看，如：
+
+```
+[
+ [
+ {
+ "fileNumber": "1",
+ "totalRows": "0",
+ "fileSize": "8388608",
+ "url":
"file:///172.20.32.136/path/to/result_7052bac522d840f5-972079771289e392_*"
+ }
+ ],
+ [
+ {
+ "fileNumber": "1",
+ "totalRows": "0",
+ "fileSize": "8388608",
+ "url":
"file:///172.20.32.137/path/to/result_22aba7ec933b4922-ba81e5eca12bf0c2_*"
+ }
+ ]
+]
+```
+
:::caution
-此功能会将数据导出并写入到 BE 所在节点的磁盘上，如果有多个 BE 节点，则数据会根据导出任务的并发度分散在不同 BE
节点上，每个节点有一部分数据。此功能不适用于生产环境，并且请自行确保导出目录的权限和数据安全性。
+此功能不适用于生产环境，并且请自行确保导出目录的权限和数据安全性。
:::
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/export/outfile.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/export/outfile.md
index e835143a9f0..a7d990ff0d9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/export/outfile.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/export/outfile.md
@@ -266,7 +266,7 @@ PROPERTIES(
示例：将 tbl 表中的所有数据导出到本地文件系统，设置导出作业的文件格式为 csv（默认格式），并设置列分割符为`,`。
```sql
-SELECT c1, c2 FROM tbl FROM tbl1
+SELECT c1, c2 FROM db.tbl
INTO OUTFILE "file:///path/to/result_"
FORMAT AS CSV
PROPERTIES(
@@ -274,6 +274,23 @@ PROPERTIES(
);
```
+此功能会将数据导出并写入到 BE 所在节点的磁盘上，如果有多个 BE 节点，则数据会根据导出任务的并发度分散在不同 BE 节点上，每个节点有一部分数据。
+
+如在这个示例中，最终会在 BE 节点的 `/path/to/` 下生产一组类似
`result_c6df5f01bd664dde-a2168b019b6c2b3f_0.csv` 的文件。
+
+具体的 BE 节点 IP 会在返回的结果中显示，如：
+
+```
++------------+-----------+----------+--------------------------------------------------------------------------+
+| FileNumber | TotalRows | FileSize | URL
|
++------------+-----------+----------+--------------------------------------------------------------------------+
+| 1 | 1195072 | 4780288 |
file:///172.20.32.136/path/to/result_c6df5f01bd664dde-a2168b019b6c2b3f_* |
+| 1 | 1202944 | 4811776 |
file:///172.20.32.136/path/to/result_c6df5f01bd664dde-a2168b019b6c2b40_* |
+| 1 | 1198880 | 4795520 |
file:///172.20.32.137/path/to/result_c6df5f01bd664dde-a2168b019b6c2b43_* |
+| 1 | 1198880 | 4795520 |
file:///172.20.32.137/path/to/result_c6df5f01bd664dde-a2168b019b6c2b45_* |
++------------+-----------+----------+--------------------------------------------------------------------------+
+```
+
:::caution
-此功能会将数据导出并写入到 BE 所在节点的磁盘上，如果有多个 BE 节点，则数据会根据导出任务的并发度分散在不同 BE
节点上，每个节点有一部分数据。此功能不适用于生产环境，并且请自行确保导出目录的权限和数据安全性。
-:::
\ No newline at end of file
+此功能不适用于生产环境，并且请自行确保导出目录的权限和数据安全性。
+:::
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/export/export-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/export/export-manual.md
index 5502719067b..8c82a38cf65 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/export/export-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/export/export-manual.md
@@ -124,7 +124,7 @@ OutfileInfo: [
{
"fileNumber": "1",
"totalRows": "6001215",
- "fileSize": "747503989bytes",
+ "fileSize": "747503989",
"url": "s3://bucket/export/export_6555cd33e7447c1-baa9568b5c4eb0ac_*"
}
]
@@ -362,14 +362,41 @@ Export 任务的底层是执行`SELECT INTO OUTFILE` SQL 语句。用户发起
示例：将 tbl 表中的所有数据导出到本地文件系统，设置导出作业的文件格式为 csv（默认格式），并设置列分割符为`,`。
```sql
-EXPORT TABLE tbl TO "file:///home/user/tmp/"
+EXPORT TABLE db.tbl TO "file:///path/to/result_"
PROPERTIES (
"format" = "csv",
"line_delimiter" = ","
);
```
+此功能会将数据导出并写入到 BE 所在节点的磁盘上，如果有多个 BE 节点，则数据会根据导出任务的并发度分散在不同 BE 节点上，每个节点有一部分数据。
+
+如在这个示例中，最终会在 BE 节点的 `/path/to/` 下生产一组类似
`result_7052bac522d840f5-972079771289e392_0.csv` 的文件。
+
+具体的 BE 节点 IP 可以在 `SHOW EXPORT` 结果中的 `OutfileInfo` 列查看，如：
+
+```
+[
+ [
+ {
+ "fileNumber": "1",
+ "totalRows": "0",
+ "fileSize": "8388608",
+ "url":
"file:///172.20.32.136/path/to/result_7052bac522d840f5-972079771289e392_*"
+ }
+ ],
+ [
+ {
+ "fileNumber": "1",
+ "totalRows": "0",
+ "fileSize": "8388608",
+ "url":
"file:///172.20.32.137/path/to/result_22aba7ec933b4922-ba81e5eca12bf0c2_*"
+ }
+ ]
+]
+```
+
:::caution
-此功能会将数据导出并写入到 BE 所在节点的磁盘上，如果有多个 BE 节点，则数据会根据导出任务的并发度分散在不同 BE
节点上，每个节点有一部分数据。此功能不适用于生产环境，并且请自行确保导出目录的权限和数据安全性。
+此功能不适用于生产环境，并且请自行确保导出目录的权限和数据安全性。
:::
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/export/outfile.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/export/outfile.md
index e835143a9f0..a7d990ff0d9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/export/outfile.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/export/outfile.md
@@ -266,7 +266,7 @@ PROPERTIES(
示例：将 tbl 表中的所有数据导出到本地文件系统，设置导出作业的文件格式为 csv（默认格式），并设置列分割符为`,`。
```sql
-SELECT c1, c2 FROM tbl FROM tbl1
+SELECT c1, c2 FROM db.tbl
INTO OUTFILE "file:///path/to/result_"
FORMAT AS CSV
PROPERTIES(
@@ -274,6 +274,23 @@ PROPERTIES(
);
```
+此功能会将数据导出并写入到 BE 所在节点的磁盘上，如果有多个 BE 节点，则数据会根据导出任务的并发度分散在不同 BE 节点上，每个节点有一部分数据。
+
+如在这个示例中，最终会在 BE 节点的 `/path/to/` 下生产一组类似
`result_c6df5f01bd664dde-a2168b019b6c2b3f_0.csv` 的文件。
+
+具体的 BE 节点 IP 会在返回的结果中显示，如：
+
+```
++------------+-----------+----------+--------------------------------------------------------------------------+
+| FileNumber | TotalRows | FileSize | URL
|
++------------+-----------+----------+--------------------------------------------------------------------------+
+| 1 | 1195072 | 4780288 |
file:///172.20.32.136/path/to/result_c6df5f01bd664dde-a2168b019b6c2b3f_* |
+| 1 | 1202944 | 4811776 |
file:///172.20.32.136/path/to/result_c6df5f01bd664dde-a2168b019b6c2b40_* |
+| 1 | 1198880 | 4795520 |
file:///172.20.32.137/path/to/result_c6df5f01bd664dde-a2168b019b6c2b43_* |
+| 1 | 1198880 | 4795520 |
file:///172.20.32.137/path/to/result_c6df5f01bd664dde-a2168b019b6c2b45_* |
++------------+-----------+----------+--------------------------------------------------------------------------+
+```
+
:::caution
-此功能会将数据导出并写入到 BE 所在节点的磁盘上，如果有多个 BE 节点，则数据会根据导出任务的并发度分散在不同 BE
节点上，每个节点有一部分数据。此功能不适用于生产环境，并且请自行确保导出目录的权限和数据安全性。
-:::
\ No newline at end of file
+此功能不适用于生产环境，并且请自行确保导出目录的权限和数据安全性。
+:::
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/export/export-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/export/export-manual.md
index 5502719067b..8c82a38cf65 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/export/export-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/export/export-manual.md
@@ -124,7 +124,7 @@ OutfileInfo: [
{
"fileNumber": "1",
"totalRows": "6001215",
- "fileSize": "747503989bytes",
+ "fileSize": "747503989",
"url": "s3://bucket/export/export_6555cd33e7447c1-baa9568b5c4eb0ac_*"
}
]
@@ -362,14 +362,41 @@ Export 任务的底层是执行`SELECT INTO OUTFILE` SQL 语句。用户发起
示例：将 tbl 表中的所有数据导出到本地文件系统，设置导出作业的文件格式为 csv（默认格式），并设置列分割符为`,`。
```sql
-EXPORT TABLE tbl TO "file:///home/user/tmp/"
+EXPORT TABLE db.tbl TO "file:///path/to/result_"
PROPERTIES (
"format" = "csv",
"line_delimiter" = ","
);
```
+此功能会将数据导出并写入到 BE 所在节点的磁盘上，如果有多个 BE 节点，则数据会根据导出任务的并发度分散在不同 BE 节点上，每个节点有一部分数据。
+
+如在这个示例中，最终会在 BE 节点的 `/path/to/` 下生产一组类似
`result_7052bac522d840f5-972079771289e392_0.csv` 的文件。
+
+具体的 BE 节点 IP 可以在 `SHOW EXPORT` 结果中的 `OutfileInfo` 列查看，如：
+
+```
+[
+ [
+ {
+ "fileNumber": "1",
+ "totalRows": "0",
+ "fileSize": "8388608",
+ "url":
"file:///172.20.32.136/path/to/result_7052bac522d840f5-972079771289e392_*"
+ }
+ ],
+ [
+ {
+ "fileNumber": "1",
+ "totalRows": "0",
+ "fileSize": "8388608",
+ "url":
"file:///172.20.32.137/path/to/result_22aba7ec933b4922-ba81e5eca12bf0c2_*"
+ }
+ ]
+]
+```
+
:::caution
-此功能会将数据导出并写入到 BE 所在节点的磁盘上，如果有多个 BE 节点，则数据会根据导出任务的并发度分散在不同 BE
节点上，每个节点有一部分数据。此功能不适用于生产环境，并且请自行确保导出目录的权限和数据安全性。
+此功能不适用于生产环境，并且请自行确保导出目录的权限和数据安全性。
:::
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/export/outfile.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/export/outfile.md
index e835143a9f0..a7d990ff0d9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/export/outfile.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/export/outfile.md
@@ -266,7 +266,7 @@ PROPERTIES(
示例：将 tbl 表中的所有数据导出到本地文件系统，设置导出作业的文件格式为 csv（默认格式），并设置列分割符为`,`。
```sql
-SELECT c1, c2 FROM tbl FROM tbl1
+SELECT c1, c2 FROM db.tbl
INTO OUTFILE "file:///path/to/result_"
FORMAT AS CSV
PROPERTIES(
@@ -274,6 +274,23 @@ PROPERTIES(
);
```
+此功能会将数据导出并写入到 BE 所在节点的磁盘上，如果有多个 BE 节点，则数据会根据导出任务的并发度分散在不同 BE 节点上，每个节点有一部分数据。
+
+如在这个示例中，最终会在 BE 节点的 `/path/to/` 下生产一组类似
`result_c6df5f01bd664dde-a2168b019b6c2b3f_0.csv` 的文件。
+
+具体的 BE 节点 IP 会在返回的结果中显示，如：
+
+```
++------------+-----------+----------+--------------------------------------------------------------------------+
+| FileNumber | TotalRows | FileSize | URL
|
++------------+-----------+----------+--------------------------------------------------------------------------+
+| 1 | 1195072 | 4780288 |
file:///172.20.32.136/path/to/result_c6df5f01bd664dde-a2168b019b6c2b3f_* |
+| 1 | 1202944 | 4811776 |
file:///172.20.32.136/path/to/result_c6df5f01bd664dde-a2168b019b6c2b40_* |
+| 1 | 1198880 | 4795520 |
file:///172.20.32.137/path/to/result_c6df5f01bd664dde-a2168b019b6c2b43_* |
+| 1 | 1198880 | 4795520 |
file:///172.20.32.137/path/to/result_c6df5f01bd664dde-a2168b019b6c2b45_* |
++------------+-----------+----------+--------------------------------------------------------------------------+
+```
+
:::caution
-此功能会将数据导出并写入到 BE 所在节点的磁盘上，如果有多个 BE 节点，则数据会根据导出任务的并发度分散在不同 BE
节点上，每个节点有一部分数据。此功能不适用于生产环境，并且请自行确保导出目录的权限和数据安全性。
-:::
\ No newline at end of file
+此功能不适用于生产环境，并且请自行确保导出目录的权限和数据安全性。
+:::
diff --git a/versioned_docs/version-2.1/data-operate/export/export-manual.md
b/versioned_docs/version-2.1/data-operate/export/export-manual.md
index 47d21121e69..c493079e86f 100644
--- a/versioned_docs/version-2.1/data-operate/export/export-manual.md
+++ b/versioned_docs/version-2.1/data-operate/export/export-manual.md
@@ -125,7 +125,7 @@ OutfileInfo: [
{
"fileNumber": "1",
"totalRows": "6001215",
- "fileSize": "747503989bytes",
+ "fileSize": "747503989",
"url": "s3://bucket/export/export_6555cd33e7447c1-baa9568b5c4eb0ac_*"
}
]
@@ -363,13 +363,40 @@ If you want to enable this function, please add
`enable_outfile_to_local=true` i
Example: Export all the data in the `tbl` table to the local file system, set
the file format of the export job to csv (the default format), and set the
column delimiter to `,`.
```sql
-EXPORT TABLE tbl TO "file:///home/user/tmp/"
+EXPORT TABLE tbl TO "file:///path/to/result_"
PROPERTIES (
"format" = "csv",
"line_delimiter" = ","
);
```
+This function will export and write data to the disk of the node where the BE
is located. If there are multiple BE nodes, the data will be scattered on
different BE nodes according to the concurrency of the export task, and each
node will have a part of the data.
+
+As in this example, a set of files similar to
`result_7052bac522d840f5-972079771289e392_0.csv` will eventually be produced
under `/path/to/` of the BE node.
+
+The specific BE node IP can be viewed in the `OutfileInfo` column in the `SHOW
EXPORT` result, such as:
+
+```
+[
+ [
+ {
+ "fileNumber": "1",
+ "totalRows": "0",
+ "fileSize": "8388608",
+ "url":
"file:///172.20.32.136/path/to/result_7052bac522d840f5-972079771289e392_*"
+ }
+ ],
+ [
+ {
+ "fileNumber": "1",
+ "totalRows": "0",
+ "fileSize": "8388608",
+ "url":
"file:///172.20.32.137/path/to/result_22aba7ec933b4922-ba81e5eca12bf0c2_*"
+ }
+ ]
+]
+```
+
:::caution
-This function will export and write the data to the disks of the nodes where
the BE is located. If there are multiple BE nodes, the data will be distributed
across different BE nodes according to the concurrency of the export tasks, and
each node will have a portion of the data. This function is not applicable to
the production environment, and please ensure the permissions of the export
directory and data security on your own.
+This function is not applicable to the production environment, and please
ensure the permissions of the export directory and data security on your own.
:::
diff --git a/versioned_docs/version-2.1/data-operate/export/outfile.md
b/versioned_docs/version-2.1/data-operate/export/outfile.md
index 60dd21735d8..29565371bb0 100644
--- a/versioned_docs/version-2.1/data-operate/export/outfile.md
+++ b/versioned_docs/version-2.1/data-operate/export/outfile.md
@@ -268,7 +268,7 @@ If you want to enable this function, please add
`enable_outfile_to_local=true` i
Example: Export all the data in the tbl table to the local file system, set
the file format of the export job to csv (the default format), and set the
column separator to `,`.
```sql
-SELECT c1, c2 FROM tbl FROM tbl1
+SELECT c1, c2 FROM db.tbl
INTO OUTFILE "file:///path/to/result_"
FORMAT AS CSV
PROPERTIES(
@@ -276,6 +276,24 @@ PROPERTIES(
);
```
+This function will export and write data to the disk of the node where the BE
is located. If there are multiple BE nodes, the data will be scattered on
different BE nodes according to the concurrency of the export task, and each
node will have a part of the data.
+
+As in this example, a set of files similar to
`result_c6df5f01bd664dde-a2168b019b6c2b3f_0.csv` will eventually be produced
under `/path/to/` of the BE node.
+
+The specific BE node IP will be displayed in the returned results, such as:
+
+```
++------------+-----------+----------+--------------------------------------------------------------------------+
+| FileNumber | TotalRows | FileSize | URL
|
++------------+-----------+----------+--------------------------------------------------------------------------+
+| 1 | 1195072 | 4780288 |
file:///172.20.32.136/path/to/result_c6df5f01bd664dde-a2168b019b6c2b3f_* |
+| 1 | 1202944 | 4811776 |
file:///172.20.32.136/path/to/result_c6df5f01bd664dde-a2168b019b6c2b40_* |
+| 1 | 1198880 | 4795520 |
file:///172.20.32.137/path/to/result_c6df5f01bd664dde-a2168b019b6c2b43_* |
+| 1 | 1198880 | 4795520 |
file:///172.20.32.137/path/to/result_c6df5f01bd664dde-a2168b019b6c2b45_* |
++------------+-----------+----------+--------------------------------------------------------------------------+
+```
+
:::caution
-This function will export and write data to the disks of the nodes where the
BE is located. If there are multiple BE nodes, the data will be scattered among
different BE nodes according to the concurrency of the export tasks, and each
node will have a part of the data. This function is not suitable for the
production environment, and please ensure the permissions and data security of
the export directory on your own.
-:::
\ No newline at end of file
+This function is not suitable for the production environment, and please
ensure the permissions and data security of the export directory on your own.
+:::
+
diff --git a/versioned_docs/version-3.0/data-operate/export/export-manual.md
b/versioned_docs/version-3.0/data-operate/export/export-manual.md
index 47d21121e69..c493079e86f 100644
--- a/versioned_docs/version-3.0/data-operate/export/export-manual.md
+++ b/versioned_docs/version-3.0/data-operate/export/export-manual.md
@@ -125,7 +125,7 @@ OutfileInfo: [
{
"fileNumber": "1",
"totalRows": "6001215",
- "fileSize": "747503989bytes",
+ "fileSize": "747503989",
"url": "s3://bucket/export/export_6555cd33e7447c1-baa9568b5c4eb0ac_*"
}
]
@@ -363,13 +363,40 @@ If you want to enable this function, please add
`enable_outfile_to_local=true` i
Example: Export all the data in the `tbl` table to the local file system, set
the file format of the export job to csv (the default format), and set the
column delimiter to `,`.
```sql
-EXPORT TABLE tbl TO "file:///home/user/tmp/"
+EXPORT TABLE tbl TO "file:///path/to/result_"
PROPERTIES (
"format" = "csv",
"line_delimiter" = ","
);
```
+This function will export and write data to the disk of the node where the BE
is located. If there are multiple BE nodes, the data will be scattered on
different BE nodes according to the concurrency of the export task, and each
node will have a part of the data.
+
+As in this example, a set of files similar to
`result_7052bac522d840f5-972079771289e392_0.csv` will eventually be produced
under `/path/to/` of the BE node.
+
+The specific BE node IP can be viewed in the `OutfileInfo` column in the `SHOW
EXPORT` result, such as:
+
+```
+[
+ [
+ {
+ "fileNumber": "1",
+ "totalRows": "0",
+ "fileSize": "8388608",
+ "url":
"file:///172.20.32.136/path/to/result_7052bac522d840f5-972079771289e392_*"
+ }
+ ],
+ [
+ {
+ "fileNumber": "1",
+ "totalRows": "0",
+ "fileSize": "8388608",
+ "url":
"file:///172.20.32.137/path/to/result_22aba7ec933b4922-ba81e5eca12bf0c2_*"
+ }
+ ]
+]
+```
+
:::caution
-This function will export and write the data to the disks of the nodes where
the BE is located. If there are multiple BE nodes, the data will be distributed
across different BE nodes according to the concurrency of the export tasks, and
each node will have a portion of the data. This function is not applicable to
the production environment, and please ensure the permissions of the export
directory and data security on your own.
+This function is not applicable to the production environment, and please
ensure the permissions of the export directory and data security on your own.
:::
diff --git a/versioned_docs/version-3.0/data-operate/export/outfile.md
b/versioned_docs/version-3.0/data-operate/export/outfile.md
index 60dd21735d8..29565371bb0 100644
--- a/versioned_docs/version-3.0/data-operate/export/outfile.md
+++ b/versioned_docs/version-3.0/data-operate/export/outfile.md
@@ -268,7 +268,7 @@ If you want to enable this function, please add
`enable_outfile_to_local=true` i
Example: Export all the data in the tbl table to the local file system, set
the file format of the export job to csv (the default format), and set the
column separator to `,`.
```sql
-SELECT c1, c2 FROM tbl FROM tbl1
+SELECT c1, c2 FROM db.tbl
INTO OUTFILE "file:///path/to/result_"
FORMAT AS CSV
PROPERTIES(
@@ -276,6 +276,24 @@ PROPERTIES(
);
```
+This function will export and write data to the disk of the node where the BE
is located. If there are multiple BE nodes, the data will be scattered on
different BE nodes according to the concurrency of the export task, and each
node will have a part of the data.
+
+As in this example, a set of files similar to
`result_c6df5f01bd664dde-a2168b019b6c2b3f_0.csv` will eventually be produced
under `/path/to/` of the BE node.
+
+The specific BE node IP will be displayed in the returned results, such as:
+
+```
++------------+-----------+----------+--------------------------------------------------------------------------+
+| FileNumber | TotalRows | FileSize | URL
|
++------------+-----------+----------+--------------------------------------------------------------------------+
+| 1 | 1195072 | 4780288 |
file:///172.20.32.136/path/to/result_c6df5f01bd664dde-a2168b019b6c2b3f_* |
+| 1 | 1202944 | 4811776 |
file:///172.20.32.136/path/to/result_c6df5f01bd664dde-a2168b019b6c2b40_* |
+| 1 | 1198880 | 4795520 |
file:///172.20.32.137/path/to/result_c6df5f01bd664dde-a2168b019b6c2b43_* |
+| 1 | 1198880 | 4795520 |
file:///172.20.32.137/path/to/result_c6df5f01bd664dde-a2168b019b6c2b45_* |
++------------+-----------+----------+--------------------------------------------------------------------------+
+```
+
:::caution
-This function will export and write data to the disks of the nodes where the
BE is located. If there are multiple BE nodes, the data will be scattered among
different BE nodes according to the concurrency of the export tasks, and each
node will have a part of the data. This function is not suitable for the
production environment, and please ensure the permissions and data security of
the export directory on your own.
-:::
\ No newline at end of file
+This function is not suitable for the production environment, and please
ensure the permissions and data security of the export directory on your own.
+:::
+
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
