Implementing OpenSearch PPL Query Using OpenSearch Plugin

Grafana
,
1

Hey team,
Hope you are doing well.
We are new to OpenSearch and want to query data on it. This is the query we used on OpenSearch to visualize our expected data:

search source=<index> | stats count() by process.serviceName, operationName

It works and data can be visualized, so we decided to move on to Grafana as well. However, when use the same query on Grafana using OpenSearch plugin, it always shows “Invalid Query” without much helpful information.
Our OpenSearch version is 2.12.0 and the OpenSearch plugin shows “Index OK” when we test it on Grafana. Can someone plz have a look? Any suggestion is appreciated, thank you.

2

highly recommend using infinity plugin using the open search url ip.address:9200

3

Will try that, thank you