Hi, does opensearch support Promql? If not, is there any direction towards it. Having this feature would be very helpful for us since we are planning to move some workloads from prometheus to opensearch.
I have seen a previous post long back requesting this feature, but there hasn’t been any response.
PromQL is specifically designed to query and analyze time series and is built for a time series database. OpenSearch is not good at handling time series data. The OpenSearch project has an integration to Prometheus (or any PromQL datasource) which enables the analysis of metrics from those datasources : Metrics analytics - OpenSearch Documentation This is a much more scalable and smarter approach to the problem versus trying to put metrics in a document database
@jkowall Thank’s for responding to my question. It seems like Metrics analytics - OpenSearch Documentation is for visualizing the metrics stored in prometheus. We are not looking for that.
For our usecase, we want to move the data itself to opensearch, since we find that prometheus is not able to handle huge amount of data. The data is not strictly timeseries.
But we have other components which already retrieve the data using promql. So that’s why the request for promql.
Unfortunately, OpenSearch does not currently support PromQL. Consider submitting a feature request or exploring community plugins for this capability.