[Bug] [task-hivecli] Unable to read resource files in Hive CLI

[wangbowen1024]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

I get a error, when i use HiveCLI and read SQL from File:

Caused by: java.io.FileNotFoundException: /tmp/dolphinscheduler320/exec/process//11975691665664/11975844729729_4/17/22/hdfs://user/dolphinscheduler320/***/resources/测试/HIVECLI.hql (No such file or directory)

so, i debug the code in IDEA. and then i find some issues from the file path:

and then i find a filed:

so i change the code

and return right path

What you expected to happen

return right path, just like issue describe

How to reproduce

every time when use hiveCLI read SQL from file

Anything else

No response

Version

3.2.x

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

I get a error, when i use HiveCLI and read SQL from File:

Caused by: java.io.FileNotFoundException: /tmp/dolphinscheduler320/exec/process//11975691665664/11975844729729_4/17/22/hdfs://user/dolphinscheduler320/***/resources/测试/HIVECLI.hql (No such file or directory)

so, i debug the code in IDEA. and then i find some issues from the file path:

and then i find a filed:

so i change the code

and return right path

What you expected to happen

return right path, just like issue describe

How to reproduce

every time when use hiveCLI read SQL from file

Anything else

No response

Version

3.2.x

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[ruanwenjun]

This bug is imported by #12076, right now we will not store data in t_ds_resource, so the resource feature have bug.