devbox
凡人多烦事01
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

elasticsearch 父子文档（7.13）_sprinboot注解实现 elasticsearch7父子文档

作者：凡人多烦事01 | 2024-04-20 09:45:13

赞

踩

sprinboot注解实现 elasticsearch7父子文档

elasticsearch 父子文档

             

官网：https://www.elastic.co/guide/en/elasticsearch/reference/7.13/parent-join.html

has parent query：https://www.elastic.co/guide/en/elasticsearch/reference/7.13/query-dsl-has-parent-query.html

has child query：https://www.elastic.co/guide/en/elasticsearch/reference/7.13/query-dsl-has-child-query.html

parent id query：https://www.elastic.co/guide/en/elasticsearch/reference/7.13/query-dsl-parent-id-query.html#parent-id-query-ex-request

children aggregation：https://www.elastic.co/guide/en/elasticsearch/reference/7.13/search-aggregations-bucket-children-aggregation.html

                  

                     

********************

join field type

              

join类型在同一个index内创建文档的父子关系

  1. PUT my-index-000001
  2. {
  3.   "mappings": {
  4.     "properties": {
  5.       "my_id": {
  6.         "type": "keyword"
  7.       },
  8.       "my_join_field": {            
  9.         "type": "join",            # my_join_field为join字段
  10.         "relations": {
  11.           "question": "answer"     # question：父文档标识
  12.         }                          # answer：子文档标识
  13.       }
  14.     }
  15.   }
  16. }

                

创建父文档

  1. PUT my-index-000001/_doc/1?refresh
  2. {
  3.   "my_id": "1",
  4.   "text": "This is a question",
  5.   "my_join_field": {
  6.     "name": "question" 
  7.   }
  8. }
  9.  
  10.  
  11. # 简化写法
  12. PUT my-index-000001/_doc/2?refresh
  13. {
  14.   "my_id": "2",
  15.   "text": "This is another question",
  16.   "my_join_field": "question"
  17. }

               

创建子文档

  1. PUT my-index-000001/_doc/3?routing=1&refresh
  2. {
  3.   "my_id": "3",
  4.   "text": "This is an answer",
  5.   "my_join_field": {
  6.     "name": "answer",      # 子文档标识
  7.     "parent": "1"          # 父文档id
  8.   }
  9. }
  10.  
  11. 说明：routing字段必须，父子文档必须在同一个分片（shard）上

            

性能说明

  1. The join field shouldn’t be used like joins in a relation database. 
  2. In Elasticsearch the key to good performance is to de-normalize your 
  3. data into documents. 
  4. # join字段不应该该像关系型数据库那样使用，从性能方面考虑，可以进行反范式设计
  5.  
  6. Each join field, has_child or has_parent query adds a significant tax 
  7. to your query performance.
  8. # join字段、has_child query、has_parent query都会影响查询性能
  9.  
  10.  
  11. The only case where the join field makes sense is if your data contains 
  12. a one-to-many relationship where one entity significantly outnumbers 
  13. the other entity.
  14. # join字段常用于一对多的关系

               

join 使用限制

  1. Only one join field mapping is allowed per index.
  2. # 同一个index最多只能使用一个join字段
  3.  
  4. Parent and child documents must be indexed on the same shard.
  5. # 父子文档必须在同一个分片（shard）上
  6.  
  7. An element can have multiple children but only one parent.
  8. # 一个文档可以有多个子文档，但最多只能有一个父文档
  9.  
  10. It is possible to add a new relation to an existing join field.
  11. # 可以在join字段中添加新的关联关系（子文档可以成为其他文档的父文档）
  12.  
  13. It is also possible to add a child to an existing element but 
  14. only if the element is already a parent.
  15. # 只能给父文档添加子文档

                

******************

多重父子关联（multiple levels of parent join）

              

                                           

  1. PUT my-index-000001
  2. {
  3.   "mappings": {
  4.     "properties": {
  5.       "my_join_field": {
  6.         "type": "join",
  7.         "relations": {
  8.           "question": ["answer", "comment"],  
  9.           "answer": "vote" 
  10.         }
  11.       }
  12.     }
  13.   }
  14. }

 说明：多重父子关联会影响查询性能，不推荐使用，

              

创建文档

  1. # 文档 1
  2. PUT my-index-000001/_doc/1?refresh
  3. {
  4.   "my_id": "1",
  5.   "text": "This is a question",
  6.   "my_join_field": "question" 
  7. }
  8.  
  9. # 文档 2：文档 1的子文档
  10. PUT my-index-000001/_doc/2?routing=1&refresh      #routing的值为文档 1的路由id
  11. {
  12.   "my_id": "3",
  13.   "text": "This is an answer",
  14.   "my_join_field": {
  15.     "name": "answer", 
  16.     "parent": "1"               # 父文档的id（文档 1）
  17.   }
  18. }
  19.  
  20.  
  21. # 文档 3：文档 2的子文档
  22. PUT my-index-000001/_doc/3?routing=1&refresh       #routing的值为文档 1的路由id
  23. {
  24.   "text": "This is a vote",
  25.   "my_join_field": {
  26.     "name": "vote",
  27.     "parent": "2"               # 父文档的id（文档 2）
  28.   }
  29. }

                   

                      

********************

has parent query

          

查询条件为父文档，查询结果为子文档

  1. # 索引 my-index-000001
  2. PUT /my-index-000001
  3. {
  4.   "mappings": {
  5.     "properties": {
  6.       "my-join-field": {
  7.         "type": "join",
  8.         "relations": {
  9.           "parent": "child"
  10.         }
  11.       },
  12.       "tag": {
  13.         "type": "keyword"
  14.       }
  15.     }
  16.   }
  17. }
  18.  
  19.  
  20. # 查询条件：父文档tag=Elasticsearch
  21. GET /my-index-000001/_search
  22. {
  23.   "query": {
  24.     "has_parent": {
  25.       "parent_type": "parent",
  26.       "query": {
  27.         "term": {
  28.           "tag": {
  29.             "value": "Elasticsearch"
  30.           }
  31.         }
  32.       }
  33.     }
  34.   }
  35. }

           

相关参数

  1. parent_type：必须，父文档标识
  2. query：必须，搜索匹配的父文档，返回对应的子文档
  3.  
  4. score：可选，true、false（默认）
  5. (Optional, Boolean) Indicates whether the relevance score of a 
  6. matching parent document is aggregated into its child documents.
  7. false：父文档的score不会计入子文档
  8. true：父文档的score会计入子文档
  9.  
  10. ignore_unmapped：可选，true、false（默认）
  11. (Optional, Boolean) Indicates whether to ignore an unmapped 
  12. parent_type and not return any documents instead of an error
  13. false：父文档类型不匹配，返回error
  14. true：父文档类型不匹配，不返回error

                 

                         

********************

has child query

            

查询条件为子文档，返回父文档

  1. # 索引：my-index-000001
  2. PUT /my-index-000001
  3. {
  4.   "mappings": {
  5.     "properties": {
  6.       "my-join-field": {
  7.         "type": "join",
  8.         "relations": {
  9.           "parent": "child"
  10.         }
  11.       }
  12.     }
  13.   }
  14. }
  15.  
  16.  
  17. # 查询条件：最少有2个子文档、最多有10个子文档
  18. GET /_search
  19. {
  20.   "query": {
  21.     "has_child": {
  22.       "type": "child",
  23.       "query": {
  24.         "match_all": {}     #匹配所有子文档
  25.       },
  26.       "max_children": 10,   #最多10个子文档
  27.       "min_children": 2,    #最少2个子文档
  28.       "score_mode": "min"   #返回最少得分
  29.     }
  30.   }
  31. }

                

相关参数

  1. type：必选，子文档标识
  2. query：必选，匹配子文档
  3.  
  4. ignore_unmapped：可选，true、false（默认）
  5. (Optional, Boolean) Indicates whether to ignore an unmapped 
  6. type and not return any documents instead of an error
  7. false：文档标识不匹配，返回error
  8. true：文档表示不匹配，不返回error
  9.  
  10. max_children：可选，最多含有满足条件的子文档数，超过该值不返回父文档
  11. min_children：可选，最少含有满足条件的子文档数，小于该值不返回父文档
  12.  
  13. score_mode：可选，标识子文档得分如何影响父文档得分，可选值如下
  14.   none (Default)：无影响，父文档得分为0
  15.   avg：所有匹配子文档的平均得分
  16.   max：所有匹配子文档的最高得分
  17.   min：所有匹配子文档的最低得分
  18.   sum：所有匹配子文档得分和

                 

                  

********************

parent id query

父文档的id值为指定值，返回子文档

  1. # 索引：my-index-000001
  2. PUT /my-index-000001
  3. {
  4.   "mappings": {
  5.     "properties": {
  6.       "my-join-field": {
  7.         "type": "join",
  8.         "relations": {
  9.           "my-parent": "my-child"
  10.         }
  11.       }
  12.     }
  13.   }
  14. }
  15.  
  16.  
  17. # 插入父文档
  18. PUT /my-index-000001/_doc/1?refresh
  19. {
  20.   "text": "This is a parent document.",
  21.   "my-join-field": "my-parent"
  22. }
  23.  
  24. # 插入子文档
  25. PUT /my-index-000001/_doc/2?routing=1&refresh
  26. {
  27.   "text": "This is a child document.",
  28.   "my_join_field": {
  29.     "name": "my-child",
  30.     "parent": "1"
  31.   }
  32. }
  33.  
  34.  
  35. # 查询条件：父文档的id=1
  36. GET /my-index-000001/_search
  37. {
  38.   "query": {
  39.       "parent_id": {
  40.           "type": "my-child",
  41.           "id": "1"
  42.       }
  43.   }
  44. }

               

相关参数

  1. type：必选，子文档标识
  2. id：必选，父文档 id
  3.  
  4. ignore_unmapped：可选，true、false（默认）
  5. (Optional, Boolean) Indicates whether to ignore an unmapped 
  6. type and not return any documents instead of an error
  7. false：子文档表示不匹配，返回error
  8. true：子文档表示不匹配，不返回error

                

               

********************

children aggregation

            

字聚合：特殊的单桶聚合（a special single bucket aggregation），根据join 子标识字段聚合，

  1. # 新建索引：child_example
  2. PUT child_example
  3. {
  4.   "mappings": {
  5.     "properties": {
  6.       "join": {
  7.         "type": "join",
  8.         "relations": {
  9.           "question": "answer"
  10.         }
  11.       }
  12.     }
  13.   }
  14. }
  15.  
  16.  
  17. # 父文档
  18. PUT child_example/_doc/1
  19. {
  20.   "join": {
  21.     "name": "question"
  22.   },
  23.   "body": "<p>I have Windows 2003 server and i bought a new Windows 2008 server...",
  24.   "title": "Whats the best way to file transfer my site from server to a newer one?",
  25.   "tags": [
  26.     "windows-server-2003",
  27.     "windows-server-2008",
  28.     "file-transfer"
  29.   ]
  30. }
  31.  
  32.  
  33. # 子文档
  34. PUT child_example/_doc/2?routing=1
  35. {
  36.   "join": {
  37.     "name": "answer",
  38.     "parent": "1"
  39.   },
  40.   "owner": {
  41.     "location": "Norfolk, United Kingdom",
  42.     "display_name": "Sam",
  43.     "id": 48
  44.   },
  45.   "body": "<p>Unfortunately you're pretty much limited to FTP...",
  46.   "creation_date": "2009-05-04T13:45:37.030"
  47. }
  48.  
  49.  
  50. # 子文档
  51. PUT child_example/_doc/3?routing=1&refresh
  52. {
  53.   "join": {
  54.     "name": "answer",
  55.     "parent": "1"
  56.   },
  57.   "owner": {
  58.     "location": "Norfolk, United Kingdom",
  59.     "display_name": "Troll",
  60.     "id": 49
  61.   },
  62.   "body": "<p>Use Linux...",
  63.   "creation_date": "2009-05-05T13:45:37.030"
  64. }

              

children aggregation

  1. POST child_example/_search?size=0
  2. {
  3.   "aggs": {
  4.     "top-tags": {            # 父文档根据字段tags聚合
  5.       "terms": {
  6.         "field": "tags.keyword",
  7.         "size": 10
  8.       },
  9.       "aggs": {
  10.         "to-answers": {
  11.           "children": {       # children 聚合
  12.             "type" : "answer" 
  13.           },
  14.           "aggs": {
  15.             "top-names": {
  16.               "terms": {      # 子文档根据owner.diaplay_name聚合
  17.                 "field": "owner.display_name.keyword",
  18.                 "size": 10
  19.               }
  20.             }
  21.           }
  22.         }
  23.       }
  24.     }
  25.   }
  26. }

             

聚合结果

  1. {
  2.   "took": 25,
  3.   "timed_out": false,
  4.   "_shards": {
  5.     "total": 1,
  6.     "successful": 1,
  7.     "skipped" : 0,
  8.     "failed": 0
  9.   },
  10.   "hits": {
  11.     "total" : {
  12.       "value": 3,
  13.       "relation": "eq"
  14.     },
  15.     "max_score": null,
  16.     "hits": []
  17.   },
  18.   "aggregations": {
  19.     "top-tags": {
  20.       "doc_count_error_upper_bound": 0,
  21.       "sum_other_doc_count": 0,
  22.       "buckets": [
  23.         {
  24.           "key": "file-transfer",
  25.           "doc_count": 1, 
  26.           "to-answers": {
  27.             "doc_count": 2, 
  28.             "top-names": {
  29.               "doc_count_error_upper_bound": 0,
  30.               "sum_other_doc_count": 0,
  31.               "buckets": [
  32.                 {
  33.                   "key": "Sam",
  34.                   "doc_count": 1
  35.                 },
  36.                 {
  37.                   "key": "Troll",
  38.                   "doc_count": 1
  39.                 }
  40.               ]
  41.             }
  42.           }
  43.         },
  44.         {
  45.           "key": "windows-server-2003",
  46.           "doc_count": 1, 
  47.           "to-answers": {
  48.             "doc_count": 2, 
  49.             "top-names": {
  50.               "doc_count_error_upper_bound": 0,
  51.               "sum_other_doc_count": 0,
  52.               "buckets": [
  53.                 {
  54.                   "key": "Sam",
  55.                   "doc_count": 1
  56.                 },
  57.                 {
  58.                   "key": "Troll",
  59.                   "doc_count": 1
  60.                 }
  61.               ]
  62.             }
  63.           }
  64.         },
  65.         {
  66.           "key": "windows-server-2008",
  67.           "doc_count": 1, 
  68.           "to-answers": {
  69.             "doc_count": 2, 
  70.             "top-names": {
  71.               "doc_count_error_upper_bound": 0,
  72.               "sum_other_doc_count": 0,
  73.               "buckets": [
  74.                 {
  75.                   "key": "Sam",
  76.                   "doc_count": 1
  77.                 },
  78.                 {
  79.                   "key": "Troll",
  80.                   "doc_count": 1
  81.                 }
  82.               ]
  83.             }
  84.           }
  85.         }
  86.       ]
  87.     }
  88.   }
  89. }

                 

                     

********************

示例

           

join ==> school:student

父文档：id、name、join（school）

子文档：id、name、sex、join（student）

                 

创建索引

  1. PUT school_student
  2. {
  3.   "mappings": {
  4.     "properties": {
  5.       "join": {
  6.         "type": "join",
  7.         "relations": {
  8.           "school": "student"
  9.         }
  10.       }
  11.     }
  12.   }
  13. }

                

插入父文档

  1. PUT school_student/_doc/1
  2. {
  3.   "name":"火影忍者",
  4.   "join": "school"
  5. }
  6.  
  7. PUT school_student/_doc/2
  8. {
  9.   "name":"海贼王",
  10.   "join": "school"
  11. }

               

插入子文档：parent = 1

  1. # parent 1的子文档
  2. PUT school_student/_doc/3?routing=1
  3. {
  4.   "name":"鸣人",
  5.   "sex": "male",
  6.   "join": {
  7.     "name":"student",
  8.     "parent": 1
  9.   }
  10. }
  11.  
  12. PUT school_student/_doc/4?routing=1
  13. {
  14.   "name":"雏田",
  15.   "sex": "female",
  16.   "join": {
  17.     "name":"student",
  18.     "parent": 1
  19.   }
  20. }
  21.  
  22. PUT school_student/_doc/5?routing=1
  23. {
  24.   "name":"小樱",
  25.   "sex": "female",
  26.   "join": {
  27.     "name":"student",
  28.     "parent": 1
  29.   }
  30. }
  31.  
  32. PUT school_student/_doc/6?routing=1
  33. {
  34.   "name":"二柱子",
  35.   "sex": "male",
  36.   "join": {
  37.     "name":"student",
  38.     "parent": 1
  39.   }
  40. }

                  

插入子文档：parent = 2

  1. PUT school_student/_doc/7?routing=2
  2. {
  3.   "name":"路飞",
  4.   "sex": "male",
  5.   "join": {
  6.     "name":"student",
  7.     "parent": 2
  8.   }
  9. }
  10.  
  11. PUT school_student/_doc/8?routing=2
  12. {
  13.   "name":"绿藻头",
  14.   "sex": "male",
  15.   "join": {
  16.     "name":"student",
  17.     "parent": 2
  18.   }
  19. }
  20.  
  21. PUT school_student/_doc/9?routing=2
  22. {
  23.   "name":"色厨子",
  24.   "sex": "male",
  25.   "join": {
  26.     "name":"student",
  27.     "parent": 2
  28.   }
  29. }
  30.  
  31. PUT school_student/_doc/10?routing=2
  32. {
  33.   "name":"撒谎布",
  34.   "sex": "male",
  35.   "join": {
  36.     "name":"student",
  37.     "parent": 2
  38.   }
  39. }
  40.  
  41. PUT school_student/_doc/11?routing=2
  42. {
  43.   "name":"娜美",
  44.   "sex": "female",
  45.   "join": {
  46.     "name":"student",
  47.     "parent": 2
  48.   }
  49. }
  50.  
  51. PUT school_student/_doc/12?routing=2
  52. {
  53.   "name":"罗宾",
  54.   "sex": "female",
  55.   "join": {
  56.     "name":"student",
  57.     "parent": 2
  58.   }
  59. }

                   

                      

parent id query：parent id = 1的子文档

  1. # 查询语句
  2. GET school_student/_search
  3. {
  4.   "query": {
  5.       "parent_id": {
  6.           "type": "student",
  7.           "id": "1"
  8.       }
  9.   }
  10. }
  11.  
  12.  
  13. # 查询结果：返回4条子文档
  14. {
  15.   "took" : 1021,
  16.   "timed_out" : false,
  17.   "_shards" : {
  18.     "total" : 1,
  19.     "successful" : 1,
  20.     "skipped" : 0,
  21.     "failed" : 0
  22.   },
  23.   "hits" : {
  24.     "total" : {
  25.       "value" : 4,
  26.       "relation" : "eq"
  27.     },
  28.     "max_score" : 0.6325226,
  29.     "hits" : [
  30.       {
  31.         "_index" : "school_student",
  32.         "_type" : "_doc",
  33.         "_id" : "3",
  34.         "_score" : 0.6325226,
  35.         "_routing" : "1",
  36.         "_source" : {
  37.           "name" : "鸣人",
  38.           "sex" : "male",
  39.           "join" : {
  40.             "name" : "student",
  41.             "parent" : 1
  42.           }
  43.         }
  44.       },
  45.       {
  46.         "_index" : "school_student",
  47.         "_type" : "_doc",
  48.         "_id" : "4",
  49.         "_score" : 0.6325226,
  50.         "_routing" : "1",
  51.         "_source" : {
  52.           "name" : "雏田",
  53.           "sex" : "female",
  54.           "join" : {
  55.             "name" : "student",
  56.             "parent" : 1
  57.           }
  58.         }
  59.       },
  60.       {
  61.         "_index" : "school_student",
  62.         "_type" : "_doc",
  63.         "_id" : "5",
  64.         "_score" : 0.6325226,
  65.         "_routing" : "1",
  66.         "_source" : {
  67.           "name" : "小樱",
  68.           "sex" : "female",
  69.           "join" : {
  70.             "name" : "student",
  71.             "parent" : 1
  72.           }
  73.         }
  74.       },
  75.       {
  76.         "_index" : "school_student",
  77.         "_type" : "_doc",
  78.         "_id" : "6",
  79.         "_score" : 0.6325226,
  80.         "_routing" : "1",
  81.         "_source" : {
  82.           "name" : "二柱子",
  83.           "sex" : "male",
  84.           "join" : {
  85.             "name" : "student",
  86.             "parent" : 1
  87.           }
  88.         }
  89.       }
  90.     ]
  91.   }
  92. }

                   

has child query：查询包含子文档name = 罗宾的父文档

  1. # 查询语句
  2. GET school_student/_search
  3. {
  4.   "query": {
  5.       "has_child": {
  6.         "type": "student",
  7.         "query": {
  8.           "match": {
  9.             "name": "罗宾"
  10.           }
  11.         }
  12.       }
  13.   }
  14. }
  15.  
  16.  
  17. # 查询结果
  18. {
  19.   "took" : 4,
  20.   "timed_out" : false,
  21.   "_shards" : {
  22.     "total" : 1,
  23.     "successful" : 1,
  24.     "skipped" : 0,
  25.     "failed" : 0
  26.   },
  27.   "hits" : {
  28.     "total" : {
  29.       "value" : 1,
  30.       "relation" : "eq"
  31.     },
  32.     "max_score" : 1.0,
  33.     "hits" : [
  34.       {
  35.         "_index" : "school_student",
  36.         "_type" : "_doc",
  37.         "_id" : "2",
  38.         "_score" : 1.0,
  39.         "_source" : {
  40.           "name" : "海贼王",
  41.           "join" : "school"
  42.         }
  43.       }
  44.     ]
  45.   }
  46. }

                    

has parent query：查询父文档name = 海贼王的子文档

  1. # 查询语句
  2. GET school_student/_search
  3. {
  4.   "query": {
  5.       "has_parent": {
  6.         "parent_type": "school",
  7.         "query": {
  8.           "match": {
  9.             "name": "海贼王"
  10.           }
  11.         }
  12.       }
  13.   }
  14. }
  15.  
  16.  
  17. # 查询结果
  18. {
  19.   "took" : 7,
  20.   "timed_out" : false,
  21.   "_shards" : {
  22.     "total" : 1,
  23.     "successful" : 1,
  24.     "skipped" : 0,
  25.     "failed" : 0
  26.   },
  27.   "hits" : {
  28.     "total" : {
  29.       "value" : 6,
  30.       "relation" : "eq"
  31.     },
  32.     "max_score" : 1.0,
  33.     "hits" : [
  34.       {
  35.         "_index" : "school_student",
  36.         "_type" : "_doc",
  37.         "_id" : "7",
  38.         "_score" : 1.0,
  39.         "_routing" : "2",
  40.         "_source" : {
  41.           "name" : "路飞",
  42.           "sex" : "male",
  43.           "join" : {
  44.             "name" : "student",
  45.             "parent" : 2
  46.           }
  47.         }
  48.       },
  49.       {
  50.         "_index" : "school_student",
  51.         "_type" : "_doc",
  52.         "_id" : "8",
  53.         "_score" : 1.0,
  54.         "_routing" : "2",
  55.         "_source" : {
  56.           "name" : "绿藻头",
  57.           "sex" : "male",
  58.           "join" : {
  59.             "name" : "student",
  60.             "parent" : 2
  61.           }
  62.         }
  63.       },
  64.       {
  65.         "_index" : "school_student",
  66.         "_type" : "_doc",
  67.         "_id" : "9",
  68.         "_score" : 1.0,
  69.         "_routing" : "2",
  70.         "_source" : {
  71.           "name" : "色厨子",
  72.           "sex" : "male",
  73.           "join" : {
  74.             "name" : "student",
  75.             "parent" : 2
  76.           }
  77.         }
  78.       },
  79.       {
  80.         "_index" : "school_student",
  81.         "_type" : "_doc",
  82.         "_id" : "10",
  83.         "_score" : 1.0,
  84.         "_routing" : "2",
  85.         "_source" : {
  86.           "name" : "撒谎布",
  87.           "sex" : "male",
  88.           "join" : {
  89.             "name" : "student",
  90.             "parent" : 2
  91.           }
  92.         }
  93.       },
  94.       {
  95.         "_index" : "school_student",
  96.         "_type" : "_doc",
  97.         "_id" : "11",
  98.         "_score" : 1.0,
  99.         "_routing" : "2",
  100.         "_source" : {
  101.           "name" : "娜美",
  102.           "sex" : "female",
  103.           "join" : {
  104.             "name" : "student",
  105.             "parent" : 2
  106.           }
  107.         }
  108.       },
  109.       {
  110.         "_index" : "school_student",
  111.         "_type" : "_doc",
  112.         "_id" : "12",
  113.         "_score" : 1.0,
  114.         "_routing" : "2",
  115.         "_source" : {
  116.           "name" : "罗宾",
  117.           "sex" : "female",
  118.           "join" : {
  119.             "name" : "student",
  120.             "parent" : 2
  121.           }
  122.         }
  123.       }
  124.     ]
  125.   }
  126. }

                  

chidren query：查询不同school下的男女人数

  1. # 查询语句
  2. GET school_student/_search
  3. {
  4.   "query": {
  5.     "terms": {
  6.       "name.keyword":  ["火影忍者","海贼王"]
  7.     }
  8.   }, 
  9.   "aggs": {
  10.       "school_count": {
  11.         "terms": {
  12.           "field": "name.keyword",
  13.           "size": 10
  14.         },
  15.         "aggs": {
  16.           "student_count": {
  17.             "children": {
  18.               "type": "student"
  19.             },
  20.             "aggs": {
  21.               "sex_count": {
  22.                 "terms": {
  23.                   "field": "sex.keyword",
  24.                   "size": 10
  25.                 }
  26.               }
  27.             }
  28.           }
  29.         }
  30.       }
  31.   }
  32. }
  33.  
  34.  
  35. # 查询结果
  36. {
  37.   "took" : 11,
  38.   "timed_out" : false,
  39.   "_shards" : {
  40.     "total" : 1,
  41.     "successful" : 1,
  42.     "skipped" : 0,
  43.     "failed" : 0
  44.   },
  45.   "hits" : {
  46.     "total" : {
  47.       "value" : 2,
  48.       "relation" : "eq"
  49.     },
  50.     "max_score" : 1.0,
  51.     "hits" : [
  52.       {
  53.         "_index" : "school_student",
  54.         "_type" : "_doc",
  55.         "_id" : "1",
  56.         "_score" : 1.0,
  57.         "_source" : {
  58.           "name" : "火影忍者",
  59.           "join" : "school"
  60.         }
  61.       },
  62.       {
  63.         "_index" : "school_student",
  64.         "_type" : "_doc",
  65.         "_id" : "2",
  66.         "_score" : 1.0,
  67.         "_source" : {
  68.           "name" : "海贼王",
  69.           "join" : "school"
  70.         }
  71.       }
  72.     ]
  73.   },
  74.   "aggregations" : {
  75.     "school_count" : {
  76.       "doc_count_error_upper_bound" : 0,
  77.       "sum_other_doc_count" : 0,
  78.       "buckets" : [
  79.         {
  80.           "key" : "海贼王",
  81.           "doc_count" : 1,
  82.           "student_count" : {
  83.             "doc_count" : 6,
  84.             "sex_count" : {
  85.               "doc_count_error_upper_bound" : 0,
  86.               "sum_other_doc_count" : 0,
  87.               "buckets" : [
  88.                 {
  89.                   "key" : "male",
  90.                   "doc_count" : 4
  91.                 },
  92.                 {
  93.                   "key" : "female",
  94.                   "doc_count" : 2
  95.                 }
  96.               ]
  97.             }
  98.           }
  99.         },
  100.         {
  101.           "key" : "火影忍者",
  102.           "doc_count" : 1,
  103.           "student_count" : {
  104.             "doc_count" : 4,
  105.             "sex_count" : {
  106.               "doc_count_error_upper_bound" : 0,
  107.               "sum_other_doc_count" : 0,
  108.               "buckets" : [
  109.                 {
  110.                   "key" : "female",
  111.                   "doc_count" : 2
  112.                 },
  113.                 {
  114.                   "key" : "male",
  115.                   "doc_count" : 2
  116.                 }
  117.               ]
  118.             }
  119.           }
  120.         }
  121.       ]
  122.     }
  123.   }
  124. }

                 

             

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/凡人多烦事01/article/detail/456687
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号