[Subtask]: Modify the optimizer to support obtaining tasks from each AMS node for processing.

[wardlican]

Search before asking

• [x] I have searched in the issues and found no similar issues.

Description

In master-slave mode, the optimizer needs to support pulling optimization tasks from each ams node for processing.

Parent issue

https://github.com/apache/amoro/issues/3670

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