es 子文档查询

最新推荐文章于 2025-06-11 09:07:57 发布

原创最新推荐文章于 2025-06-11 09:07:57 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#es #search #nested

程序人生专栏收录该内容

44 篇文章

订阅专栏

本文档介绍了如何在ElasticSearch中进行子文档查询，包括创建索引和映射、添加文档，以及检索和设置检索选项。通过示例展示了如何获取匹配的内嵌文档，并解释了from和size参数用于控制返回结果的数量。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

使用方法

Nested inner hitsedit

创建索引及映射

PUT test
{
  "mappings": {
    "_doc": {
      "properties": {
        "comments": {
          "type": "nested"
        }
      }
    }
  }
}

创建文档

PUT test/_doc/1
{
  "title": "Test title",
  "comments": [
	              {
	                  "author": "kimchy",
	                  "number": 1,
	                  "like": "dog"
	              },
	              {
	                  "author": "nik9000",
	                  "number": 2,
	                  "like": "dog"
	              },
	              {
	                  "author": "tom",
	                  "number": 4,
	                  "like": "cat"
	              },
	              {
	                  "author": "nik900",
	                  "number": 2,
	                  "like": "dog"
	              }
  ]
}

检索

POST test/_search
{
  "query": {
    "nested": {
      "path": "comments",
      "query": {
        "match": {"comments.number" : 2}
      },
      "inner_hits": {} 
    }
  }
}

结果

{
{
    "took": 13,
    "timed_out": false,
    "_shards": {
        "total": 5,
        "successful": 5,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": 1,
        "max_score": 0.24116206,
        "hits": [
            {
                "_index": "test_index",
                "_type": "_doc",
                "_id": "1",
                "_score": 0.24116206,
                "_source": {
                    "title": "Test title",
                    "comments": [
                        {
                            "author": "kimchy",
                            "number": 1,
                            "like": "dog"
                        },
                        {
                            "author": "nik9000",
                            "number": 2,
                            "like": "dog"
                        },
                        {
                            "author": "tom",
                            "number": 4,
                            "like": "cat"
                        },
                        {
                            "author": "nik900",
                            "number": 2,
                            "like": "dog"
                        }
                    ]
                },
                "inner_hits": {
                    "comments": {
                        "hits": {
                            "total": 3,
                            "max_score": 0.24116206,
                            "hits": [
                                {
                                    "_index": "test_index",
                                    "_type": "_doc",
                                    "_id": "1",
                                    "_nested": {
                                        "field": "comments",
                                        "offset": 5
                                    },
                                    "_score": 0.24116206,
                                    "_source": {
                                        "author": "kimchy",
                                        "number": 1,
                                        "like": "dog"
                                    }
                                },
                                {
                                    "_index": "test_index",
                                    "_type": "_doc",
                                    "_id": "1",
                                    "_nested": {
                                        "field": "comments",
                                        "offset": 4
                                    },
                                    "_score": 0.24116206,
                                    "_source": {
                                        "author": "nik9000",
                                        "number": 2,
                                        "like": "dog"
                                    }
                                },
                                {
                                    "_index": "test_index",
                                    "_type": "_doc",
                                    "_id": "1",
                                    "_nested": {
                                        "field": "comments",
                                        "offset": 3
                                    },
                                    "_score": 0.24116206,
                                    "_source": {
                                        "author": "nik900",
                                        "number": 2,
                                        "like": "dog"
                                    }
                                }
                            ]
                        }
                    }
                }
            }
        ]
    }
}

选项说明：

from
The offset from where the first hit to fetch for each inner_hits in the returned regular search hits.
size
The maximum number of hits to return per inner_hits. By default the top three matching hits are returned.
sort
How the inner hits should be sorted per inner_hits. By default the hits are sorted by the score.