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 997f7ecc07 [typo](doc)Add a demo of export minio (#20323)
997f7ecc07 is described below
commit 997f7ecc07f38bcdadf16c7a5ca13f1420ddd85d
Author: yuanyuan8983 <[email protected]>
AuthorDate: Sat Jun 3 16:59:32 2023 +0800
[typo](doc)Add a demo of export minio (#20323)
---
.../Manipulation/EXPORT.md | 20 ++++++++++++++++++--
.../Manipulation/EXPORT.md | 21 +++++++++++++++++++--
2 files changed, 37 insertions(+), 4 deletions(-)
diff --git
a/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
b/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
index 7a215ad35d..10b6198ec8 100644
---
a/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
+++
b/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
@@ -233,10 +233,10 @@ Before exporting data, all files and directories in the
`/home/user/` directory
#### export with S3
-8. Export all data from the `testTbl` table to S3 using invisible character
'\x07' as a delimiter for columns and rows.
+8. Export all data from the `testTbl` table to S3 using invisible character
'\x07' as a delimiter for columns and rows.If you want to export data to minio,
you also need to specify use_path_style=true.
```sql
-EXPORT TABLE testTbl TO "s3://hdfs_host:port/a/b/c"
+EXPORT TABLE testTbl TO "s3://bucket/a/b/c"
PROPERTIES (
"column_separator"="\\x07",
"line_delimiter" = "\\x07"
@@ -248,6 +248,22 @@ PROPERTIES (
)
```
+```sql
+EXPORT TABLE minio_test TO "s3://bucket/a/b/c"
+PROPERTIES (
+ "column_separator"="\\x07",
+ "line_delimiter" = "\\x07"
+) WITH s3 (
+ "AWS_ENDPOINT" = "xxxxx",
+ "AWS_ACCESS_KEY" = "xxxxx",
+ "AWS_SECRET_KEY"="xxxx",
+ "AWS_REGION" = "xxxxx",
+ "use_path_style" = "true"
+)
+```
+
+9. Export all data in the test table to HDFS in the format of parquet, limit
the size of a single file to 1024MB, and reserve all files in the specified
directory.
+
#### export with HDFS
```sql
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
index e23f18b565..187233f378 100644
---
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
+++
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/EXPORT.md
@@ -227,10 +227,10 @@ Export导出数据时会先将`/home/user/`目录下所有文件及目录删除
#### export with S3
-8. 将 testTbl 表中的所有数据导出到 s3 上，以不可见字符 "\x07" 作为列或者行分隔符。
+8. 将 s3_test 表中的所有数据导出到 s3 上，以不可见字符 "\x07"
作为列或者行分隔符。如果需要将数据导出到minio，还需要指定use_path_style=true。
```sql
-EXPORT TABLE testTbl TO "s3://hdfs_host:port/a/b/c"
+EXPORT TABLE s3_test TO "s3://bucket/a/b/c"
PROPERTIES (
"column_separator"="\\x07",
"line_delimiter" = "\\x07"
@@ -242,7 +242,24 @@ PROPERTIES (
)
```
+```sql
+EXPORT TABLE minio_test TO "s3://bucket/a/b/c"
+PROPERTIES (
+ "column_separator"="\\x07",
+ "line_delimiter" = "\\x07"
+) WITH s3 (
+ "AWS_ENDPOINT" = "xxxxx",
+ "AWS_ACCESS_KEY" = "xxxxx",
+ "AWS_SECRET_KEY"="xxxx",
+ "AWS_REGION" = "xxxxx",
+ "use_path_style" = "true"
+)
+```
+
#### export with HDFS
+
+9. 将 test 表中的所有数据导出到 HDFS 上，导出文件格式为parquet，导出作业单个文件大小限制为1024MB，保留所指定目录下的所有文件。
+
```sql
EXPORT TABLE test TO "hdfs://hdfs_host:port/a/b/c/"
PROPERTIES(
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
