es之关联查询_es 左右关联

es并不擅长关联查询，其提供的解决方案有三种：对象，嵌套对象，父子文档

一，对象

POST moive/_doc/1
{
  "movie":"first blog",
  "actors":[{
    "firstName":"lu",
    "lastName":"yong"
  },{
    "firstName":"liu",
    "lastName":"yo3ng"
  }
 ]
}

GET moive/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "actors.firstName":"lu"
          }
        },
        {
          "match": {
            "actors.lastName":"yo3ng"
          }
        }
      ]
    }
  }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

二，嵌套对象

PUT my_movie
{
  "mappings": {
    "properties": {
       "actors":{
         "type":"nested", 
         "properties": {
           "lastName": {
             "type":"keyword"
           },
           "firstName": {
             "type":"keyword"
           }
         }
       }
    }
  }
}

POST my_movie/_doc/1
{
  "title":"speed",
  "actors":[
    {
      "firstName":"zhou",
      "lastName":"yong"
    },
    {
      "firstName":"lu",
      "lastName":"ha"
    }
  ]
}

GET my_movie/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "title": "speed"
          }
        },
        {
          "nested": {
            "path": "actors",
            "query": {
              "bool": {
                "must": [
                  {"match":{"actors.firstName":"zhou"}},
                  {"match":{"actors.lastName":"yong"}}
                ]
              }
            }
          }
        }
      ]
    }
  }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61

三，父子文档

父子文档的本身是同一个索引的两个类别，创建文档时指定标识表示其是父文档和子文档，在子文档中指定父文档的id。

1， 定义父子文档

PUT my_blog
{
  "mappings": {
    "properties": {
      "blog_comment_relation":{
        "type": "join",
        "relations":{
          "blog":"comment"
        }
      }
    }
  }
}
1
2
3
4
5
6
7
8
9
10
11
12
13

2，插入父文档

POST my_blog/_doc/blog1
{
  "title":"hadoop good",
  "author":"george",
  "blog_comment_relation":{
    "name":"blog"
  }
}

POST my_blog/_doc/blog2
{
  "title":"elastic search",
  "author":"george",
  "blog_comment_relation":{
    "name":"blog"
  }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

3，插入子文档

POST my_blog/_doc/comment1?routing=blog1
{
  "title":"i love hadoop search",
  "author":"george",
  "blog_comment_relation":{
    "name":"comment",
    "parent":"blog1"
  }
}

POST my_blog/_doc/comment2?routing=blog2
{
  "title":"i love elastic search",
  "author":"george",
  "blog_comment_relation":{
    "name":"comment",
    "parent":"blog2"
  }
}

POST my_blog/_search
{
  "query": {
    "has_parent": {
      "parent_type": "blog",
      "query": {
        "match": {
          "title": "hadoop"
        }
      }
    }
  }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

4，查询

// 查询评论
POST my_blog/_search
{
  "query": {
    "parent_id":{
      "type":"comment",
      "id":"blog1"
    }
  }
}

// 查询评论
POST my_blog/_search
{
  "query": {
    "has_child": {
      "type": "comment",
      "query": {
        "match": {
          "author": "george"
        }
      }
    }
  }
}

GET my_blog/_doc/blog1


GET my_blog/_doc/comment1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30