[es] nested aggregation

검색쿼리

GET /products_nested/_search?size=0
{
  "query": {
    "match": {
      "name": "led tv"
    }
  },
  "aggs": {
    "resellers": {
      "nested": {
        "path": "resellers"
      },
      "aggs": {
        "filter_reseller": {
          "filter": {
            "bool": {
              "filter": [
                {
                  "term": {
                    "resellers.reseller": "companyB"
                  }
                }
              ]
            }
          },
          "aggs": {
            "min_price": {
              "min": {
                "field": "resellers.price"
              }
            },
            "resller": {
              "terms": {
                "field": "resellers.reseller",
                "size": 10
              }
            }
          }
        }
      }
    }
  }
}

 

PUT /products_nested
{
  "settings": {
    "index": {
      "number_of_shards": 3,
      "number_of_replicas": 0
    }
  },
  "mappings": {
    "properties": {
      "resellers": {
        "type": "nested",
        "properties": {
          "reseller": {
            "type": "keyword"
          },
          "price": {
            "type": "double"
          }
        }
      }
    }
  }
}

PUT /products_nested/_doc/0?refresh
{
  "name": "LED TV", 
  "resellers": [
    {
      "reseller": "companyA",
      "price": 350
    },
    {
      "reseller": "companyB",
      "price": 500
    }
  ]
}


PUT /products_nested/_doc/1?refresh
{
  "name": "ODIO RADIO", 
  "resellers": [
    {
      "reseller": "companyA",
      "price": 150
    },
    {
      "reseller": "companyC",
      "price": 550
    }
  ]
}