导出查询结果集到本地文件系统偶然性报错

[LCehoennardo]

执行同一个导出语句，有时会报文件找不到的错误，而有时又不会，请问有人遇到过吗？
代码如下：

select app_id,user_id,sum(stay_time) from db_test.ads_report_log
where app_id='xxxxx'
and stay_time is not null
and is_play=1
and user_id regexp '^u_'
group by app_id,user_id
INTO OUTFILE "file:///home/opsadmin/test/result_"
FORMAT AS CSV
PROPERTIES
(
    "column_separator" = ",",
    "line_delimiter" = "\n",
    "max_file_size" = "100MB"
);

报错内容是：No such file or directory

[LCehoennardo]

by the way, Doris 版本是1.0.0

[dataalive]

几个BE和FE？这看起来像是跑到不同的节点上，对应节点不一定有这个目录或者权限？

[LCehoennardo]

多谢！确实是跑到了不同节点上了，在所有节点上都建对应的目录就正常了。