记录es的URI search搜索方式(一)

已于 2023-03-29 14:29:41 修改
阅读量1.1k 收藏 2
点赞数 1
分类专栏： elasticsearch 文章标签： elasticsearch 大数据 搜索引擎
于 2023-03-29 00:16:43 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xiezuozhen/article/details/129802754
版权 
在前一篇的文章中我们讲述了关于es的一些关于文档、索引、集群的基本的应用，仅仅起了个开头的作用。
在这一篇中我们将学习es的一些更高级的用法以及更详细的用法。主要是包括搜索和聚合。其中是搜索有普通搜索，
结构化搜索、全文检索、join查询、复合查询、地理信息查询、对查询结果处理、调整相关度进行查询。
聚合主要包括桶聚合、指标聚合、管道聚合，可能会稍微介绍一下矩阵聚合。
接下里我们开始我们的学习之路！！！

一、 搜索

一、URI search

首先我们摘取从《elasticsearch技术解析与实战》中的一张关于URI search的参数表格

参数解释
q查询字符串，例如q=syslog
df当查询中没有定义前缀的时候默认使用的字段
analyzer当分析查询字符串的时候使用的分词器
lowercase_expanded_terms搜索的时候忽略大小写标志,默认为true
analyzer_wildcard通配符或者前缀查询是否被分析，默认为false
default_operator默认多个条件的关系，AND或者OR，默认OR
lenient如果设置为true，字段类型转换失败的时候将被忽略，默认为false
explain在每个返回结果中，将包含评分机制的解释
_source是否包含元数据，同时支持_source_include和_source_exclude
fields只返回索引中指定的列，多个列中间用逗号分开
sort根据字段名排序，例如fieldName:asc或者fieldName:desc
track_scores评分轨迹，当排序的时候，true表示返回评分的信息
timeout超时的时间设置
terminate_after在每个分片查询的最大条数，如果设置，返回结果中会有一个terminate_early字段
from返回的索引匹配结果的开始值,默认为0
size搜索结果返回的条数，默认为10
search_type搜索的类型，可以是dfs_query_then_fetch、query_then_fetch,默认为query_then_fetch

上述多个参数在使用的时候用&分开即可。下面我们开始学习使用URL search：

一、Query String Syntax的用法

GET bank/_search?q=Nanette

据说性能不好，因为它是对所有的文档进行了查询，搜索是否包含Nanette。

GET bank/_search?q=Nanette
{
"profile": "true"
}

此处仅仅添加了条件q=Nanette，所以查询的时候会去查询所有的字段中包含Nanette的信息，这一点我们通过profile返回的信息也可以看出来。
profile是在查询的时候可以输出查询的具体执行路径。即执行计划。由于篇幅的问题，我只在这一个查询中使用，后续的查询我们只学习查询的方式，不会再去查看具体的查询执行流程。自己学习的时候可以私下运行执行计划。
返回结果为:

{
  "took" : 2,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 1,
      "relation" : "eq"
    },
    "max_score" : 6.5042877,
    "hits" : [
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "13",
        "_score" : 6.5042877,
        "_source" : {
          "account_number" : 13,
          "balance" : 32838,
          "firstname" : "Nanette",
          "lastname" : "Bates",
          "age" : 28,
          "gender" : "F",
          "address" : "789 Madison Street",
          "employer" : "Quility",
          "email" : "nanettebates@quility.com",
          "city" : "Nogal",
          "state" : "VA"
        }
      }
    ]
  },
  "profile" : {
    "shards" : [
      {
        "id" : "[jW8PbSdhTOOpESX13DRBJQ][bank][0]",
        "searches" : [
          {
            "query" : [
              {
                "type" : "DisjunctionMaxQuery",
                "description" : """(MatchNoDocsQuery("failed [account_number] query, caused by number_format_exception:[For input string: "Nanette"]") | firstname:nanette | address:nanette | gender:nanette | city:nanette | lastname.keyword:Nanette | gender.keyword:Nanette | city.keyword:Nanette | lastname:nanette | email.keyword:Nanette | firstname.keyword:Nanette | employer.keyword:Nanette | MatchNoDocsQuery("failed [balance] query, caused by number_format_exception:[For input string: "Nanette"]") | state.keyword:Nanette | employer:nanette | state:nanette | address.keyword:Nanette | email:nanette | MatchNoDocsQuery("failed [age] query, caused by number_format_exception:[For input string: "Nanette"]"))""",
                "time_in_nanos" : 285257,
                "breakdown" : {
                  "set_min_competitive_score_count" : 0,
                  "match_count" : 0,
                  "shallow_advance_count" : 0,
                  "set_min_competitive_score" : 0,
                  "next_doc" : 1995,
                  "match" : 0,
                  "next_doc_count" : 1,
                  "score_count" : 1,
                  "compute_max_score_count" : 0,
                  "compute_max_score" : 0,
                  "advance" : 8089,
                  "advance_count" : 1,
                  "score" : 6033,
                  "build_scorer_count" : 3,
                  "create_weight" : 157223,
                  "shallow_advance" : 0,
                  "create_weight_count" : 1,
                  "build_scorer" : 111917
                },
                "children" : [
                  {
                    "type" : "MatchNoDocsQuery",
                    "description" : """MatchNoDocsQuery("failed [account_number] query, caused by number_format_exception:[For input string: "Nanette"]")""",
                    "time_in_nanos" : 2115,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 1346,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 769
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "firstname:nanette",
                    "time_in_nanos" : 35870,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 3,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 1,
                      "compute_max_score_count" : 3,
                      "compute_max_score" : 731,
                      "advance" : 863,
                      "advance_count" : 2,
                      "score" : 3138,
                      "build_scorer_count" : 3,
                      "create_weight" : 22778,
                      "shallow_advance" : 896,
                      "create_weight_count" : 1,
                      "build_scorer" : 7464
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "address:nanette",
                    "time_in_nanos" : 7593,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 7119,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 474
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "gender:nanette",
                    "time_in_nanos" : 1900,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 1560,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 340
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "city:nanette",
                    "time_in_nanos" : 11893,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 11525,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 368
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "lastname.keyword:Nanette",
                    "time_in_nanos" : 5070,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 4715,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 355
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "gender.keyword:Nanette",
                    "time_in_nanos" : 1801,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 1526,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 275
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "city.keyword:Nanette",
                    "time_in_nanos" : 7737,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 7355,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 382
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "lastname:nanette",
                    "time_in_nanos" : 4524,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 4178,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 346
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "email.keyword:Nanette",
                    "time_in_nanos" : 1986,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 1661,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 325
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "firstname.keyword:Nanette",
                    "time_in_nanos" : 11564,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 3,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 1,
                      "compute_max_score_count" : 3,
                      "compute_max_score" : 2440,
                      "advance" : 497,
                      "advance_count" : 2,
                      "score" : 264,
                      "build_scorer_count" : 3,
                      "create_weight" : 5632,
                      "shallow_advance" : 455,
                      "create_weight_count" : 1,
                      "build_scorer" : 2276
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "employer.keyword:Nanette",
                    "time_in_nanos" : 6058,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 5688,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 370
                    }
                  },
                  {
                    "type" : "MatchNoDocsQuery",
                    "description" : """MatchNoDocsQuery("failed [balance] query, caused by number_format_exception:[For input string: "Nanette"]")""",
                    "time_in_nanos" : 1217,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 479,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 738
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "state.keyword:Nanette",
                    "time_in_nanos" : 4342,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 3525,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 817
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "employer:nanette",
                    "time_in_nanos" : 6783,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 6042,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 741
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "state:nanette",
                    "time_in_nanos" : 3225,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 2904,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 321
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "address.keyword:Nanette",
                    "time_in_nanos" : 2001,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 1614,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 387
                    }
                  },
                  {
                    "type" : "TermQuery",
                    "description" : "email:nanette",
                    "time_in_nanos" : 7383,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 7023,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 360
                    }
                  },
                  {
                    "type" : "MatchNoDocsQuery",
                    "description" : """MatchNoDocsQuery("failed [age] query, caused by number_format_exception:[For input string: "Nanette"]")""",
                    "time_in_nanos" : 852,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 0,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 0,
                      "next_doc" : 0,
                      "match" : 0,
                      "next_doc_count" : 0,
                      "score_count" : 0,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 0,
                      "build_scorer_count" : 2,
                      "create_weight" : 410,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 442
                    }
                  }
                ]
              }
            ],
            "rewrite_time" : 4769,
            "collector" : [
              {
                "name" : "SimpleTopScoreDocCollector",
                "reason" : "search_top_hits",
                "time_in_nanos" : 15204
              }
            ]
          }
        ],
        "aggregations" : [ ]
      }
    ]
  }
}
二、GET bank/_search?q=+Nanette
q=+Nanette的意思就是搜索一定包含Nanette这个词的文档，相反q=-Nanette的意思就是一定不包含Nanette这个词的文档。
由于q=-Nanette输出的文档过多，这里就不展示了，读者自行测试即可

返回结果:

{
  "took" : 2,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 1,
      "relation" : "eq"
    },
    "max_score" : 6.5042877,
    "hits" : [
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "13",
        "_score" : 6.5042877,
        "_source" : {
          "account_number" : 13,
          "balance" : 32838,
          "firstname" : "Nanette",
          "lastname" : "Bates",
          "age" : 28,
          "gender" : "F",
          "address" : "789 Madison Street",
          "employer" : "Quility",
          "email" : "nanettebates@quility.com",
          "city" : "Nogal",
          "state" : "VA"
        }
      }
    ]
  }
}
三、GET bank/_search?q=firstname:Nanette
GET bank/_search?q=firstname:Nanette
其实就是指定firstname这个字段进行查询

返回结果为:

{
  "took" : 1,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 1,
      "relation" : "eq"
    },
    "max_score" : 6.5042877,
    "hits" : [
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "13",
        "_score" : 6.5042877,
        "_source" : {
          "account_number" : 13,
          "balance" : 32838,
          "firstname" : "Nanette",
          "lastname" : "Bates",
          "age" : 28,
          "gender" : "F",
          "address" : "789 Madison Street",
          "employer" : "Quility",
          "email" : "nanettebates@quility.com",
          "city" : "Nogal",
          "state" : "VA"
        }
      }
    ]
  }
}
四、GET bank/_search?q=address:“Hutchinson Court”
GET bank/_search?q=address:"Hutchinson Court"
加双引号的是Phrase查询，即短语查询，可以通过执行计划看出来，底层使用的是短语查询。
GET bank/_search?q=address:(Hutchinson AND Court)
这里底层进行的是boolean查询，也可以自己通过执行计划看出来。
其中比较重要的一点就是短语查询的话，必须保证词语的顺序，不然查询不出来。
两者都实现了AND功能。但是底层机制是不一样的。

返回结果：

{
  "took" : 1,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 1,
      "relation" : "eq"
    },
    "max_score" : 8.628372,
    "hits" : [
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "18",
        "_score" : 8.628372,
        "_source" : {
          "account_number" : 18,
          "balance" : 4180,
          "firstname" : "Dale",
          "lastname" : "Adams",
          "age" : 33,
          "gender" : "M",
          "address" : "467 Hutchinson Court",
          "employer" : "Boink",
          "email" : "daleadams@boink.com",
          "city" : "Orick",
          "state" : "MD"
        }
      }
    ]
  }
}
五、GET bank/_search?q=address:Hutchinson Court
GET bank/_search?q=address:Hutchinson Court
这里其实是一个term查询，通过执行计划可以看出来
GET bank/_search?q=address:(Hutchinson Court)
这里又是一个boolean查询，
虽然这两个都实现了OR查询，即address字段中包含Hutchinson或者Court，但是两者底层查询的方式是不一样。可以自己执行，
查看他们的具体执行计划

返回结果:

{
  "took" : 1,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 119,
      "relation" : "eq"
    },
    "max_score" : 8.628372,
    "hits" : [
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "18",
        "_score" : 8.628372,
        "_source" : {
          "account_number" : 18,
          "balance" : 4180,
          "firstname" : "Dale",
          "lastname" : "Adams",
          "age" : 33,
          "gender" : "M",
          "address" : "467 Hutchinson Court",
          "employer" : "Boink",
          "email" : "daleadams@boink.com",
          "city" : "Orick",
          "state" : "MD"
        }
      },
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "56",
        "_score" : 2.1258574,
        "_source" : {
          "account_number" : 56,
          "balance" : 14992,
          "firstname" : "Josie",
          "lastname" : "Nelson",
          "age" : 32,
          "gender" : "M",
          "address" : "857 Tabor Court",
          "employer" : "Emtrac",
          "email" : "josienelson@emtrac.com",
          "city" : "Sunnyside",
          "state" : "UT"
        }
      }
    ]
  }
}
六、GET bank/_search?q=address:(Hutchinson NOT Tabor)
GET bank/_search?q=address:(Hutchinson NOT Tabor)
表示包含Hutchinson不包含Tabor

返回结果:

{
  "took" : 1,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 1,
      "relation" : "eq"
    },
    "max_score" : 6.5025153,
    "hits" : [
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "18",
        "_score" : 6.5025153,
        "_source" : {
          "account_number" : 18,
          "balance" : 4180,
          "firstname" : "Dale",
          "lastname" : "Adams",
          "age" : 33,
          "gender" : "M",
          "address" : "467 Hutchinson Court",
          "employer" : "Boink",
          "email" : "daleadams@boink.com",
          "city" : "Orick",
          "state" : "MD"
        }
      }
    ]
  }
}
七、GET bank/_search?q=age:<36
GET bank/_search?q=age:<36
表示的是范围查询，当然范围查询还有另一种形式:
GET bank/_search?q=age:{30 TO 36};开区间
GET bank/_search?q=age:[* TO 36];闭区间

返回结果:

{
  "took" : 1,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 762,
      "relation" : "eq"
    },
    "max_score" : 1.0,
    "hits" : [
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "13",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 13,
          "balance" : 32838,
          "firstname" : "Nanette",
          "lastname" : "Bates",
          "age" : 28,
          "gender" : "F",
          "address" : "789 Madison Street",
          "employer" : "Quility",
          "email" : "nanettebates@quility.com",
          "city" : "Nogal",
          "state" : "VA"
        }
      },
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "18",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 18,
          "balance" : 4180,
          "firstname" : "Dale",
          "lastname" : "Adams",
          "age" : 33,
          "gender" : "M",
          "address" : "467 Hutchinson Court",
          "employer" : "Boink",
          "email" : "daleadams@boink.com",
          "city" : "Orick",
          "state" : "MD"
        }
      }
    ]
  }
}
八、GET bank/_search?q=firstname:De*
GET bank/_search?q=firstname:De*
表示的是通配符查询,当然还有?,问号表示的是一个字符，而*表示的是0个或者多个字符

返回结果:

{
  "took" : 1,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 12,
      "relation" : "eq"
    },
    "max_score" : 1.0,
    "hits" : [
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "70",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 70,
          "balance" : 38172,
          "firstname" : "Deidre",
          "lastname" : "Thompson",
          "age" : 33,
          "gender" : "F",
          "address" : "685 School Lane",
          "employer" : "Netplode",
          "email" : "deidrethompson@netplode.com",
          "city" : "Chestnut",
          "state" : "GA"
        }
      },
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "102",
        "_score" : 1.0,
        "_source" : {
          "account_number" : 102,
          "balance" : 29712,
          "firstname" : "Dena",
          "lastname" : "Olson",
          "age" : 27,
          "gender" : "F",
          "address" : "759 Newkirk Avenue",
          "employer" : "Hinway",
          "email" : "denaolson@hinway.com",
          "city" : "Choctaw",
          "state" : "NJ"
        }
      }
    ]
  }
}
九、GET bank/_search?q=firstname:Deidr~2
GET bank/_search?q=firstname:Deidr~2
模糊查询，但是我也不知道这个后面的2是什么意思，看了一圈也没几个解释清楚的，也尝试自己改变了这个值，但是还是捉摸不透，
等后面越来越熟悉了再回来编辑一波。如果有知道的小伙伴，可以在下方留言告知我一声，我直接编辑。

返回结果:

{
  "took" : 2,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 2,
      "relation" : "eq"
    },
    "max_score" : 5.2034307,
    "hits" : [
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "70",
        "_score" : 5.2034307,
        "_source" : {
          "account_number" : 70,
          "balance" : 38172,
          "firstname" : "Deidre",
          "lastname" : "Thompson",
          "age" : 33,
          "gender" : "F",
          "address" : "685 School Lane",
          "employer" : "Netplode",
          "email" : "deidrethompson@netplode.com",
          "city" : "Chestnut",
          "state" : "GA"
        }
      },
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "463",
        "_score" : 3.902573,
        "_source" : {
          "account_number" : 463,
          "balance" : 36672,
          "firstname" : "Heidi",
          "lastname" : "Acosta",
          "age" : 20,
          "gender" : "F",
          "address" : "692 Kenmore Terrace",
          "employer" : "Elpro",
          "email" : "heidiacosta@elpro.com",
          "city" : "Ezel",
          "state" : "SD"
        }
      }
    ]
  }
}

小结

上面的Query String Syntax用法基本都讲到了，下面我们就把上面的基本用法结合一下，然后搜索一下。

GET bank/_search?q=firstname:De~2 AND age:{30 TO 36] AND address:Court* AND employer:(Entropix Eplosion Boink) 
AND gender:(NOT M) OR state:AL

返回结果:

{
  "took" : 2,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 2,
      "relation" : "eq"
    },
    "max_score" : 12.178019,
    "hits" : [
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "903",
        "_score" : 12.178019,
        "_source" : {
          "account_number" : 903,
          "balance" : 10238,
          "firstname" : "Wade",
          "lastname" : "Page",
          "age" : 35,
          "gender" : "F",
          "address" : "685 Waldorf Court",
          "employer" : "Eplosion",
          "email" : "wadepage@eplosion.com",
          "city" : "Welda",
          "state" : "AL"
        }
      },
      {
        "_index" : "bank",
        "_type" : "account",
        "_id" : "761",
        "_score" : 8.506945,
        "_source" : {
          "account_number" : 761,
          "balance" : 7663,
          "firstname" : "Rae",
          "lastname" : "Juarez",
          "age" : 34,
          "gender" : "F",
          "address" : "560 Gilmore Court",
          "employer" : "Entropix",
          "email" : "raejuarez@entropix.com",
          "city" : "Northchase",
          "state" : "ID"
        }
      }
    ]
  }
}

所以相对来讲Query String Syntax的用法不仅挺多的，而且还非常的灵活的。

基本上关于Query String Syntax的相关的用法大概就这么多吧，本来想用一篇博客把其他参数的用法也学习的，但是看着篇幅，我觉得用一篇来写，可能就太多了，所以后面其他参数的使用我会另外开一篇博客来写。

泛舟五湖之间
关注
  • 1
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
ES 查询一，基于URL 的查询
问道至简
11-21 5127
ES 查询 URI Search ， 基于URL 的查询 DSL Search ， 基于 DSL 语言的查询 URI Search 汲取 命令 说明 /_search 在所有索引上搜索 /index1/_search 在 index1 索引上搜索 /index1,index2/_search 在 index1 , index2 索引上搜索 /index*/_search 在 index 开头的索引上搜索 ...............................
ES之API系列--通过Url查询的方法(有实例)
IT利刃出鞘的博客
10-09 3398
原文网址： 简介 说明 本文介绍ElasticSearch如何通过Rest API（URL）来查询数据。 Elasticsearch有两种查询方式 URI带有查询条件(轻量查询) 查询能力有限，只适合比较简单的查询。 请求体中带有查询条件(复杂查询) 查询条件以JSON格式表现，作为查询请求的请求体，适合复杂的查询 。 官网 Search API | Elasticsearch Reference [7.15] | Elastic url查询 请求参数位于_...
ES查询之url search
epitomizelu的专栏
04-19 2855
文章目录一，url search二，url search三，不指定字段四，指定字段五，phase query六，keyword query七，term_query八，逻辑查询 AND or %2b九，逻辑查询 NOT or %2b十，数学符号十一，范围查询十二，通配符查询十三，模糊查询近似度查询1：单词写错也能查，注意后面的波浪线符号**近似度查询2：phase查询，中间缺单词也能查，注意后面的波...
橘子学ES11之URI搜索方式
liuwenqiang1314的博客
07-14 395
uri查询。
Elasticsearch Search API 概述与URI Search
最新发布
m0_54816834的博客
03-14 680
光给面试题不给答案不是我的风格。这里面的面试题也只是凤毛麟角，还有答案的话会极大的增加文章的篇幅，减少文章的可读性。
URL Schemes入门指南
iflychenyang的专栏
02-09 7284
想要更好地使用IOS 系统，对URL Schemes有一定了解是必须的。但因为 URL Schemes 的使用方式相对复杂，导致多数用户难以理解。而且大多数目前正在使用 URL Schemes 的人并不具备自己编写符合自己使用情境的 URL Schemes 的能力，他们通常是在网上搜索想要的URL Schemes，一来费时费力，二来不容易找到或者正确率不高。 实际上那些列表中的 URL
（最全）详解 URLSearchParams
前端笔记——放弃很容易,但坚持一定很酷
11-02 5636
是一个 JavaScript 内置类，用于处理（query string）的解析和构建。是 URL 中位于问号（?）后面的部分，用于传递参数和数值。例如，在以下 URL 中（https://example.com/page?name=John&age=30），查询字符串是通常可以使用 window.location.search 来获取URL中的查询字符串。我测试的初始URL是：http://127.0.0.1:5501/103001_URLSearchParams.html?name=jerry。
URLSearchParams快速解析URL查询参数
天问博客-专注于大前端技术
11-01 1532
浏览器 Window 内置的 URLSearchParams 接口定义了一些实用的方法来处理 URL 的查询字符串，再也不用 & 字符串分割的方式去解析 url query 参数了。
elasticsearch URL search
weixin_40400488的博客
03-16 164
url search 可用于查询条件少或查询条件简单的即时查询 使用浏览器地址栏即可查询数据，降低了es 的使用门槛
测试用到的es查询语法这一篇就够~
weixin_44857268的博客
11-28 3203
最近测的项目数据流是先缓存到MQ，可通过es查询，以下是es查询语法做的笔记。
Elasticsearch的多种查询方式
热门推荐
sunnyday0426的博客
07-03 1万+
Elasticsearch支持多种查询方式，包括：match查询、term查询、bool查询、range查询、prefix查询、wildcard查询、regexp查询等。这些查询方式可以组合使用，以实现复杂的搜索需求。
ES几种搜索方式
Black&White的专栏
05-01 2913
1、query string search方式的条件查询： 搜索商品名称中包含yagao的商品，而且按照售价降序排序： GET /ecommerce/product/_search?q=name:yagao&sort=price:desc 2、query DSL的方式 DSL：Domain Specified Language，特定领域的语言 查询所有的商品 GET /ecommerce...
BurpSuite插件（BP插件、武装BP）
墨痕诉清风的博客
03-07 1898
目录 解决光标错位 HAE Domain Hunter Pro passive-scan-client-0.3.0 LinkFinder HTTPHeadModifer 解决光标错位 一般我拿到Burp必做的一件事就是把光标错位调整好： User options-Display-HTTP Message Display 黑体-24px HAE https://github.com/gh0stkey/HaE 此时才把插件导入进来，需要配置你的HAE正则。 公共规..
es的URI Search详解
talen_hx的博客
12-07 522
#泛查询 GET kibana_sample_data_flights/_search?q=2021 { "profile": true } #指定字段查询 GET kibana_sample_data_flights/_search?q=timestamp:2021 { "profile": true } #布尔操作符 GET /kibana_sample_data_flights/_search?q=Dest:(Sydney AND Mind) { "profile": "true" }...
ElasticSearch搜索
qq_41029007的博客
04-12 1492
ElasticSearch搜索API 该API用于在ElasticSearch中搜索内容。用户可以通过发送带有查询字符串作为参数的get请求进行搜索，或者可以在发布请求的消息正文中发布查询。搜索 api 主要是多索引、多类型的。 URL搜索 可以使用统一资源标识符在搜索操作中传递许多参数 Q 用于指定查询字符串 lenient 此参数用于指定查询字符串。只要将此参数设置为 true，就可以忽略基于 Formatbased 的错误。默认情况下它是假的。 fields 此参数用国语指定查询的字符串 s
记录es的URI search搜索方式(二)
一枚爱钻研的小开发
04-15 297
es的uri查询详细用法
ES 实用查询、url search 整理、sql 查询对比
何xiao树
01-13 1527
这里整理用浏览器窗口查询，es数据，对比sql方便直观记录 说明：索引库名称 users 属性：name、age、sex、birthday、position 查询所有，不指定字段 select * from users; http://127.0.0.1:9200/users/_search?pretty 查询所有，指定字段 select name,age from users; ...
elasticsearch系列四：搜索详解（搜索API、Query DSL）
weixin_33911824的博客
06-22 1360
一、搜索API   1. 搜索API 端点地址 从索引tweet里面搜索字段user为kimchy的记录 GET /twitter/_search?q=user:kimchy 从索引tweet,user里面搜索字段user为kimchy的记录 GET /twitter/tweet,user/_search?q=user:kimchy GET /kimchy,elasticsearch/_...
ES查询索引字段的分词结果
duzm200542901104的专栏
04-22 9528
一、_termvectors 1、查看文档中某一个字段的分词结果 GET /{index}/{type}/{_id}/_termvectors?fields=[field] 2、样例： text的值为：https://www.b4d99.com/html/202204/45672.html GET http://IP:POST/textcontent_2022/textcontent/20220422191235893045256250/_termvectors?fields=text .
Elasticsearch入门与全面指南：安装、查询与高级搜索
- ES（Elasticsearch）是一种流行的开源搜索引擎，基于Lucene库，专为大数据量、实时搜索和分析而设计。它支持全文检索，适合处理结构化和非结构化数据，常用于日志分析、网站搜索、推荐系统等场景。 2. **安装与...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

泛舟五湖之间

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值