Date histogram API discrepancies between OpenSearch and Elasticsearch

[fmassot]

For airmail project, we need to support the OpenSearch API.

The date histogram OpenSearch uses the interval field:

json
{
  "size": 0,
  "aggs": {
    "logs_per_month": {
      "date_histogram": {
        "field": "@timestamp",
        "interval": "month"
      }
    }
  }
}

Ref

But tantivy supports only fixed_interval or calendar_interval. This corresponds to ES API. The interval field was deprecated in version 7.

We have two solutions:

• support the interval field in tantivy
• when parsing aggregation in Quickwit, we fix the query so that tantivy can run.

I suggest the first solution as the problem is "relatively" simple.

[fulmicoton]

Closed as not wanted. this feature is deprecated in both elastic and opensearch