BePPPower commented on code in PR #2233:
URL: https://github.com/apache/doris-website/pull/2233#discussion_r2011604432


##########
i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/export/export-best-practice.md:
##########
@@ -0,0 +1,102 @@
+---
+{
+    "title": "最佳实践",
+    "language": "zh-CN"
+}
+---
+
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements.  See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership.  The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License.  You may obtain a copy of the License at
+
+  http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied.  See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+本文档主要用于介绍在进行数据导出操作中,如何判断资源利用是否合理,以及如何调整资源利用率已达到更好的数据导出效率。
+
+## SELECT INTO OUTFILE
+
+1. 开启并行导出
+
+    `SELECT INTO OUTFILE` 返回的行数即代表并行的 Writer 数量。Writer 
的数量越多,则导出的并发度越高,但写出的文件数量也会越多。如果发现只有一个 Writer,则可以尝试开启并行导出功能。
+
+    `SET enable_parallel_outfile=true`
+
+    开启后,`SELECT INTO OUTFILE` 操作为根据查询的并行度来生成对应数量的 Writer。查询并行度由会话变量 
`parallel_pipeline_task_num` 控制。默认为单 BE CPU 核数的一半。
+
+    比如在一个 3 BE 节点的集群中,每个节点的 CPU 核数为 8。则开启并行导出情况下,会产生(4*3=)12 个 Writer。
+
+    注意,并不是所有查询都能够开启并行导出,比如查询中包含全局排序、聚合语义时,则无法使用并行导出。如:

Review Comment:
   ```suggestion
       注意,即使开启了并行导出功能,也不是所有查询都能够并行导出,比如查询中包含全局排序、聚合语义时,则是无法并行导出的。如:
   ```



-- 
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.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

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

Reply via email to