Sorting breaks aggregation

I use this query to get search hits and the count of search hits across multiple indices:

/index1,index2/_search
{
  "query":{
    "query_string":{
      "query":"*"
    }
  },
  "aggs":{
    "group_by_index":{
      "terms":{
        "field":"_index",
        "min_doc_count":0
      }
    }
  },
  "post_filter":{
    "terms":{
      "_index":"index1"
    }
  },
  "sort":{
    "my_field":"asc"
  }
}

The problem is if I sort on a field (my_field) that only exist in index1, the aggregation will only give me the hits count of index1, and not index2.

I thought the aggregation would work regardless of what sorting I have specified?

Using Elasticsearch 6.4

Solved it by using unmapped_type

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.