嵌套类型查询、父子级关系查询

 一、嵌套查询

1、测试数据： 不手动设置索引类型，全部使用dynamic_mapping

PUT /order/_doc/1
{
  "order_name": "扫地机器人订单",
  "desc": "shouji zhong de zhandouji",
  "goods_count": 2,
  "total_price": 12699,
  "goods_list": [
    {
      "name": "小米扫地机器人",
      "price": 1999
    },
    {
      "name": "洗碗机",
      "price": 4999
    }
  ]
}

如果直接使用bool查询name为小米扫地机器人，价格为4999的数据。按理说不会有数据，但是结果会查询出数据。

GET order/_search   使用此查询会查询出结果，但这很明显不是我们想要的
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "goods_list.name": "洗碗机"
          }
        },
        {
          "match": {
            "goods_list.price": "1999"
          }
        }
      ]
    }
  }
}

是因为goods_list字段使用了dynamic_mapping，没有设置为nested类型。es底层会将goods_list中name字段所有值放到一个数组中，price字段的所有值放到一个数组中，从而失去了一对一的关系。最终导致可以查出数据。

解决办法：

PUT order
{
  "mappings": {
    "properties": {
      "goods_list": {
        "type": "nested",
        "properties": {
          "name": {
            "type": "text",
            "analyzer": "ik_max_word",
            "fields": {
              "keyword": {
                "type": "keyword",
                "ignore_above": 256
              }
            }
          }
        }
      }
    }
  }
}

设置nested后再进行查询：

GET /order/_search
{
  "query": {
    "nested": {
      "path": "goods_list",
      "query": {
        "bool": {
          "must": [
            {
              "match": {
                "goods_list.name": "小米10"
              }
            },
            {
              "match": {
                "goods_list.price": 4999
              }
            }
          ]
        }
      }
    }
  }
}

二、父子级关系

1、设置join的mapping

PUT msb_depart
{
  "mappings": {
    "properties": {
      "msb_join_field": {
        "type": "join",     join表示存在父子级关系
        "relations": {      该字段指定父级与子级，键值对中key为父级，value为子级
          "depart": "employee"                depart为父级，employee为子级
        }
      },
      "my_id": {
        "type": "keyword"
      }
    }
  }
}

2、插入父级数据

#部门
PUT msb_depart/_doc/1
{
  "my_id": 1,
  "name":"教学部",
  "msb_join_field":{
    "name":"depart"
  }
}
PUT msb_depart/_doc/2
{
  "my_id": 2,
  "name":"咨询部",
  "msb_join_field":{
    "name":"depart"
  }
}

3、插入子级数据

# 路由值是强制性的，因为父文档和子文档必须在同一个分片上建立索引
PUT msb_depart/_doc/3?routing=1&refresh
{
  "my_id": 3,
  "name":"马老师",
  "msb_join_field":{
    "name":"employee",
    "parent":1
  }
}
PUT msb_depart/_doc/4?routing=1&refresh
{
  "my_id": 4,
  "name":"周老师",
  "msb_join_field":{
    "name":"employee",
    "parent":1
  }
}
PUT msb_depart/_doc/5?routing=1&refresh
{
  "my_id": 5,
  "name":"静静",
  "msb_join_field":{
    "name":"employee",
    "parent":2
  }
}
PUT msb_depart/_doc/6?routing=1&refresh
{
  "my_id": 6,
  "name":"球球",
  "msb_join_field":{
    "name":"employee",
    "parent":2
  }
}
PUT msb_depart/_doc/7?routing=1&refresh
{
  "my_id": 7,
  "name":"琪琪",
  "msb_join_field":{
    "name":"employee",
    "parent":2
  }
}

4、查询所有的部门

GET msb_depart/_search
{
  "query": {
    "has_child": {      has_child：有孩子说明是父亲，has_parent：有父亲说明是孩子
      "type": "employee",
      "query": {
        "match_all": {}
      }
    }
  }
}

5、搜索周老师所在的部门

GET msb_depart/_search
{
  "query": {
    "has_child": {
      "type": "employee",
      "query": {
        "match": {
          "name.keyword": "周老师"
        }
      }
    }
  }
}

6、搜索咨询部所有的老师

GET msb_depart/_search
{
  "query": {
    "has_parent": {
      "parent_type": "depart",
      "query": {
        "match": {
          "name.keyword": "咨询部"
        }
      }
    }
  }
}

7、搜索部门id为2的部门员工


GET msb_depart/_search
{
  "query": {
    "parent_id":{
      "type":"employee",
      "id":2
    }
  }
}