wyz0130 opened a new issue, #32231:
URL: https://github.com/apache/doris/issues/32231

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Version
   
   2.1.0版本
   
   ### What's Wrong?
   
   之前跟社区沟通 2.0 版本的pipeline和新优化器均没有支持并发导出的功能,
   所以 INTO OUTFILE 导出需要关闭pipeline 和 新优化器
   第一次出现问题 是set experimental_enable_nereids_planner=false;可以走并发,但是 sql 
执行完成卡住不动,hdfs 中数据已经成功导出,那时候告知需要set enable_pipeline_engine = false;  关闭后确实可以解决问题,
   现在2.1.0 也出现了这个问题,但是set enable_pipeline_engine = false 还是有
   
   
   
   ### What You Expected?
   
   2.1.0 如何开启并发
   
   ### How to Reproduce?
   
   #开启并发
        set global enable_parallel_outfile = true;
   #并发数量
        set  parallel_fragment_exec_instance_num = 3;
   #关闭优化器
        set experimental_enable_nereids_planner=false;
   #关闭 pipeline 引擎
        set enable_pipeline_engine = false;
   SELECT * FROM test1 INTO OUTFILE "hdfs://192.168.31.129:9820/doris/03/14/" 
FORMAT AS CSV PROPERTIES (     "fs.defaultFS" = "hdfs://192.168.31.129:9820", 
"hadoop.username" = "root", "column_separator" = ",", "line_delimne_delimiter" 
= "\n" );
   
   hdsf 查询
   [root@129 ~]# hdfs dfs -ls /doris/03/14
   [root@129 ~]# hdfs dfs -ls /doris/03/14
   Found 2 items
   -rw-r--r--   3 root supergroup        245 2024-03-14 14:53 
/doris/03/14/1e52702525624b4e-bec74ccc51f37847_0.csv
   -rw-r--r--   3 root supergroup         98 2024-03-14 14:53 
/doris/03/14/1e52702525624b4e-bec74ccc51f37848_0.csv
   
   sql 执行
   
![微信图片_20240314145515](https://github.com/apache/doris/assets/79512358/d982d99a-687e-48d6-b367-4f67fcbab568)
   
   
   
   
   
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


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