Order by percentiles isn't working

[maxcleme]

Kapture.2024-02-29.at.14.38.15.mp4

What happened:

I'm in the middle of migrating panels from using Elasticsearch Datasource to OpenSearch Datasource. However I can't properly Order By percentile Metrics in my Group By aggregation. When doing such, I get Invalid aggregation order path [1]. When ordering on a multi-value metrics aggregation a metric name must be specified. error. It works fine using the same setup with ES datasource.

It's also worth mentioning that the suggestion on the Order by is a bit different from Elasticsearch Datasource:

Opensearch

Elasticsearch

What you expected to happen:

I would have expect it to work, as it works in ES datasource.

How to reproduce it (as minimally and precisely as possible):

I guess video submitted shows it all.

Anything else we need to know?:

Environment:

• Grafana version: Grafana v10.2.3 (1e84fede54)
• OpenSearch version: 2.11
• Plugin version: 2.14.4

[maxcleme]

Not sure why it got tagged AWS Datasource 😅

[iwysiu]

Hi @maxcleme ! Thanks for reporting this bug. I confirmed that it works in the ElasticSearch plugin and not in the OpenSearch plugin. I'll move it to our backlog to be looked at.
Investigation notes: For reproducing it, I ran make devenv sources=elastic to run the ElasticSearch datasource and used the gdev-elasticsearch-v2-logs datasource