【弄nèng - Elasticsearch】DSL入门篇（七）—— Nested类型查询，聚合

nested类型就是为了解决object类型在对象数组上丢失关联性的问题的，如果将字段设置为nested类型，那个每一个嵌套对象都会被索引为一个 “隐藏的独立文档”。他会为每一个内部对象属性单独索引。
如果你需要保留 object 数组中每个对象的内部关系, 则需要使用 nested 类型, 而不是 [object,object] 类型.

1. nested query

添加nested属性

PUT schools/_mapping/classes
{
  "properties": {
    "users": {
      "type": "nested"
    }
  }
}

添加数据

POST schools/classes/11
{
  "classes_id": 11,
	"name": "班级11",
	"address": "深圳市福田区福华路11",
  "price": 11.4,
	"timestamp": 1572573660000,
	"users" : [
    {
      "name" : "SIMA",
      "age" :  "11",
      "price" : 13.4
    },
    {
      "name" : "LIYAO",
      "age" :  "13",
      "price" : 13.2
    }
  ]
}

查询

POST  schools/classes/_search
{
    "query":  {
        "nested" : {
            "path" : "users",
            "query" : {
                "bool" : {
                    "must" : [
                      { 
                        "match" : {
                          "users.name" : "SIMA"
                        } 
                        
                      },
                      { 
                        "range" : {
                          "users.price" : {
                            "gte" : 11,
                            "lte" : 15
                          }
                        } 
                      }
                    ]
                }
            }
        }
    }
}

效果

{
  "took": 2,
  "timed_out": false,
  "_shards": {
    "total": 3,
    "successful": 3,
    "failed": 0
  },
  "hits": {
    "total": 1,
    "max_score": 1.6931472,
    "hits": [
      {
        "_index": "schools",
        "_type": "classes",
        "_id": "11",
        "_score": 1.6931472,
        "_source": {
          "classes_id": 11,
          "name": "班级11",
          "address": "深圳市福田区福华路11",
          "price": 11.4,
          "timestamp": 1572573660000,
          "users": [
            {
              "name": "SIMA",
              "age": "11",
              "price": 13.4
            },
            {
              "name": "LIYAO",
              "age": "13",
              "price": 13.2
            }
          ]
        }
      }
    ]
  }
}

2. nested 对象聚合

POST  schools/classes/_search
{
  "size": 0, 
  "aggs": {
    "nested": {
      "nested": {
        "path": "users"
      },
      "aggs": {
        "amount_avg": {
          "avg": {
            "field": "users.price"
          }
        }
      }
    }
  }
}

效果

{
  "took": 1,
  "timed_out": false,
  "_shards": {
    "total": 3,
    "successful": 3,
    "failed": 0
  },
  "hits": {
    "total": 9,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "nested": {
      "doc_count": 2,
      "amount_avg": {
        "value": 13.299999713897705
      }
    }
  }
}

---

项目推荐

IT-CLOUD :IT服务管理平台，集成基础服务，中间件服务，监控告警服务等。
IT-CLOUD-ACTIVITI6 :Activiti教程源码。博文在本CSDN Activiti系列中。
IT-CLOUD-ELASTICSEARCH :elasticsearch教程源码。博文在本CSDN elasticsearch系列中。

开源项目，持续更新中，喜欢请 Star~