Automatic Field Grouping for Promethues Remote Storage

[killme2008]

What type of enhancement is this?

API improvement

What does the enhancement do?

As said in this article https://greptime.com/blogs/2024-03-07-greptimedb-v0.7#metric-engine

It would be great if we could support Automatic Field Grouping for the Prometheus Remote Storage extension.

Before automatically identifying related metrics, maybe we can propose a special label for users to identify related metrics, for example __datasource__ or __group__ label.

When the samples contain a special label, we can group all these metrics with the same label value into a logical time-series table.

Then user can query all these metrics in one PromQL query and do some correlation/complex analysis with SQL.

Implementation challenges

No response