[W5]: SPM Support for OpenSearch

[pipiland2612]

Requirement

Part of Native SPM support in Elasticsearch (#6641). Leverage ES query to directly derive metric data from traces
Add SPM support for opensearch

Problem

Current SPM deployment use Prometheus to store metric data. We can simplify this deployment by directly derive metric data from traces data in ES

Proposal

• Add option for opensearch inside metrics_backend
• Add docker-compose file to enable spm using opensearch
• Add corresponding e2e test

Open questions

No response

[pipiland2612]

Hi @yurishkuro , this issue is subissue of #6641