Elasticsearch Multi Search(_msearch)

最新推荐文章于 2025-05-01 08:47:50 发布

Conquer_El

最新推荐文章于 2025-05-01 08:47:50 发布

阅读量7.8k

点赞数 3

CC 4.0 BY-SA版权

分类专栏： Elasticsearch 文章标签： elasticsearch

本文链接：https://blog.csdn.net/Conquer__EL/article/details/103746122

Elasticsearch 专栏收录该内容

1 篇文章

订阅专栏

本文详细介绍Elasticsearch中批量查询的功能与使用方法，通过_msearch API，可以在单次请求中执行多条查询语句，有效减少网络开销，提高查询效率。文章包括语法格式、请求与返回示例，以及在不同索引间进行查询的实际操作。

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

文章目录

一、作用

一次连接，执行多条query语句（单个api请求中执行多个搜索）；与_mget指定id查询类似，可缩减网络开销；对于ES服务器端相对于同时收到多个请求，并没有减少太多查询耗时。

二、语法

1、请求格式(JSON)

在这里插入图片描述
如：
{}
{“query”:{}}
{}
{“query”:{}}
…
…
…
…

注意：

1、严格按照格式组装数据，一条语句一行，最后必须以换行符(\n)结尾
2、header和body是成对出现，即使header无内容也要保留“{}”并与换行结束

2、返回格式

{
“responses”:[,, …]
}

3、详见官网

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-multi-search.html#search-multi-search

三、DEMO

1、数据准备

// 创建两个索引，并添加数据
PUT my_test1
{
  "mappings": {
    "my_doc": {
      "properties": {
        "id": {
          "type": "text"
        },
        "name": {
          "type": "text"
        },
        "age": {
          "type": "integer"
        }
      }
    }
  }
}

PUT my_test2
{
  "mappings": {
    "my_doc": {
      "properties": {
        "id": {
          "type": "text"
        },
        "name": {
          "type": "text"
        },
        "age": {
          "type": "integer"
        }
      }
    }
  }
}

POST /my_test1/my_doc/1
{
  "id": "1",
  "name": "张三",
  "age": "20"
}
POST /my_test1/my_doc/2
{
  "id": "2",
  "name": "李四",
  "age": "21"
}
POST /my_test2/my_doc/3
{
  "id": "3",
  "name": "王五",
  "age": "25"
}
POST /my_test2/my_doc/4
{
  "id": "4",
  "name": "赵六",
  "age": "22"
}

2、指定index

// 查询
POST /my_test1/my_doc/_msearch
{}
{"query":{"match_all":{}}}
{}
{"query":{"match":{"name":"张三"}}}

// 结果：
{
  "responses": [
    {
      "took": 1,
      "timed_out": false,
      "_shards": {
        "total": 5,
        "successful": 5,
        "failed": 0
      },
      "hits": {
        "total": 2,
        "max_score": 1,
        "hits": [
          {
            "_index": "my_test1",
            "_type": "my_doc",
            "_id": "2",
            "_score": 1,
            "_source": {
              "id": "2",
              "name": "李四",
              "age": "21"
            }
          },
          {
            "_index": "my_test1",
            "_type": "my_doc",
            "_id": "1",
            "_score": 1,
            "_source": {
              "id": "1",
              "name": "张三",
              "age": "20"
            }
          }
        ]
      },
      "status": 200
    },
    {
      "took": 1,
      "timed_out": false,
      "_shards": {
        "total": 5,
        "successful": 5,
        "failed": 0
      },
      "hits": {
        "total": 1,
        "max_score": 0.51623213,
        "hits": [
          {
            "_index": "my_test1",
            "_type": "my_doc",
            "_id": "1",
            "_score": 0.51623213,
            "_source": {
              "id": "1",
              "name": "张三",
              "age": "20"
            }
          }
        ]
      },
      "status": 200
    }
  ]
}

3、多个index

// 查询
POST /_msearch
{"index":"my_test1"}
{"query":{"match_all":{}}}
{"index":"my_test2"}
{"query":{"match":{"name":"赵六"}}}

// 结果：
{
  "responses": [
    {
      "took": 1,
      "timed_out": false,
      "_shards": {
        "total": 5,
        "successful": 5,
        "failed": 0
      },
      "hits": {
        "total": 2,
        "max_score": 1,
        "hits": [
          {
            "_index": "my_test1",
            "_type": "my_doc",
            "_id": "2",
            "_score": 1,
            "_source": {
              "id": "2",
              "name": "李四",
              "age": "21"
            }
          },
          {
            "_index": "my_test1",
            "_type": "my_doc",
            "_id": "1",
            "_score": 1,
            "_source": {
              "id": "1",
              "name": "张三",
              "age": "20"
            }
          }
        ]
      },
      "status": 200
    },
    {
      "took": 1,
      "timed_out": false,
      "_shards": {
        "total": 5,
        "successful": 5,
        "failed": 0
      },
      "hits": {
        "total": 1,
        "max_score": 0.51623213,
        "hits": [
          {
            "_index": "my_test2",
            "_type": "my_doc",
            "_id": "4",
            "_score": 0.51623213,
            "_source": {
              "id": "4",
              "name": "赵六",
              "age": "22"
            }
          }
        ]
      },
      "status": 200
    }
  ]
}