"multi-terms" aggregation DSL query in opensearch

Hi,

I want to know if “multi-terms” aggregations query is working or not in opensearch.

I checked opensearch aggregation page documentation but didn’t find “multi-terms” aggs query.

Opensearch version - 2.0.0

Elasticsearch version > 7.12.0 supports “multi-terms” aggs.

link-
https://stackoverflow.com/questions/53478774/multiple-key-aggregation-in-elasticsearch

I tried running multi-terms aggs query but it’s throwing error.

Query-

GET titan_cal_spread/_search
{
    "aggs": {
    "genres_and_products": {
      "multi_terms": {
        "terms": [{
          "field": "upper_range" 
        }, 
        {
          "field": "lower_range"
          }]
        }
      }
    }
}

Error -

{
  "error" : {
    "root_cause" : [
      {
        "type" : "parsing_exception",
        "reason" : "Unknown aggregation type [multi_terms] did you mean [rare_terms]?",
        "line" : 4,
        "col" : 22
      }
    ],
    "type" : "parsing_exception",
    "reason" : "Unknown aggregation type [multi_terms] did you mean [rare_terms]?",
    "line" : 4,
    "col" : 22,
    "caused_by" : {
      "type" : "named_object_not_found_exception",
      "reason" : "[4:22] unknown field [multi_terms]"
    }
  },
  "status" : 400
}

Snap -

Pls let me know if I can use multi aggs query in another way.

Hi @divyank_1, the team plans to support multi-terms in OpenSearch 2.1 which is targeting this week for a release. If you are interested in doing a blog post about the feature after it is released, that would be super helpful to the community.

1 Like