wuyunfeng commented on a change in pull request #5130:
URL: https://github.com/apache/incubator-doris/pull/5130#discussion_r547751267
##########
File path: docs/en/administrator-guide/outfile.md
##########
@@ -156,7 +156,35 @@ WITH BROKER `broker_name`
If the result is less than 1GB, file will be: `result_0.parquet`.
If larger than 1GB, may be: `result_0.parquet, result_1.parquet, ...`.
+
+4. Example 4
+
+ Export simple query results to the file
`cos://${bucket_name}/path/result.txt`. Specify the export format as CSV.
+
+ ```
+ select k1,k2,v1 from tbl1 limit 100000
+ into outfile "s3a://my_bucket/export/my_file_"
+ FORMAT AS CSV
+ PROPERTIES
+ (
+ "broker.name" = "hdfs_broker",
+ "broker.fs.s3a.access.key" = "xxx",
+ "broker.fs.s3a.secret.key" = "xxxx",
+ "broker.fs.s3a.endpoint" = "https://cos.xxxxxx.myqcloud.com/";,
+ "column_separator" = ",",
+ "line_delimiter" = "\n",
+ "max_file_size" = "1024MB"
+ )
+ ```
+
+ If the result is less than 1GB, file will be: `my_file_0.csv`.
+ If larger than 1GB, may be: `my_file_0.csv, result_1.csv, ...`.
+
+ Some notes:
+ 1. Paths that do not exist are automatically created.
+ 2. These parameters(access.key/secret.key/endpointneed) need to be
confirmed with cos. In particular, the value of endpoint does not need to be
filled in bucket_name。
Review comment:
```suggestion
2. These parameters(access.key/secret.key/endpointneed) need to be
confirmed with `Tecent Cloud COS`. In particular, the value of endpoint does
not need to be filled in bucket_name。
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
