Limit ElasticSearch aggregation by type?

Question

How do you do ElasticSearch aggregation for a specific type? I understand that you can specify an index and / or type in an Url request, but I want to perform aggregations on two different types.

Thank!

Answer 1

You can filter aggregation by type, and then use subaggregation. For instance:

{
  "aggs": {
    "Test 1": {
      "filter": {
        "type": {
          "value": "type1"
        }
      },
      "aggs": {
        "agg_name": {
          "terms": {
            "field": "field1",
            "size": 10
          }
        }
      }
    },
    "Test 2": {
      "filter": {
        "type": {
          "value": "type2"
        }
      },
      "aggs": {
        "agg_name": {
          "terms": {
            "field": "field2",
            "size": 10
          }
        }
      }
    }
  }
}

Answer 2

If you can aggregate by field in all types:

curl -XGET 'localhost:9200/index/type1,type2,type3,typeN/_search/?pretty=true' -d '{
      "query": {
        "filtered": {
          "query": {
            "match_all": {}
          }
        }
      },
      "size": 0,
      "aggs": {
        "field_aggs": {
          "terms": {
            "size": 0,
            "field": "field_common_on_all_types"
          },
          "aggs": {
            "testing": {
              "terms": {
                "field": "_type"
              },
              "aggs": {
                "testing": {
                  "date_histogram": {
                    "field": "date_start",
                    "interval": "month",
                    "format": "yyyy-MM-dd HH:mm:ss"
                  }
                }
              }
            }
          }
        }
      }
    }'