reimplement elastic-search and open-search sink with rust sdk

[wenym1]

Is your feature request related to a problem? Please describe.

To support async truncation on es sink for #17095, it's better to reimplement es sink with rust sdk, which provides async functionality.

Currently, though data is written with java sdk, the json index is already built with rust code, so there should not involve too much work of extra development.

elastic-search: https://docs.rs/elasticsearch/latest/elasticsearch/
open-search: https://docs.rs/opensearch/latest/opensearch/#structs

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[github-actions]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄