search API(三) request body方式

阳光穿透心脏的1/2处 2022-12-17 10:56 139阅读 0赞

Request Body方式查询

## 一 先初始化数据 ##

post /goods/_doc/1
    {
      "name":"apple A",
      "des":"this is a apple A",
      "time":"2001-03-01"
    }
    
    post /goods/_doc/2
    {
      "name":"orange A",
      "des":"this is a orange A",
      "time":"2001-01-01"
    }
    
    post /goods/_doc/3
    {
      "name":"orange B",
      "des":"this is a orange B",
      "time":"2001-05-01"
    }
    
    post /goods/_doc/4
    {
      "name":"orange A B",
      "des":"this is a orange A B",
      "time":"2001-07-01"
    }

## 二 查询测试 ##

### 1 忽略不存在的索引 ###

\# 使用ignore\_unavailable=true 忽略不存在的索引  
post /goods,orders/\_search?ignore\_unavailable=true  
\{  
  "profile":true,  
  "query":\{  
    "match\_all":\{\}  
  \}  
\}

{
      "took" : 1,
      "timed_out" : false,
      "_shards" : {
        "total" : 1,
        "successful" : 1,
        "skipped" : 0,
        "failed" : 0
      },
      "hits" : {
        "total" : {
          "value" : 4,
          "relation" : "eq"
        },
        "max_score" : 1.0,
        "hits" : [
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "1",
            "_score" : 1.0,
            "_source" : {
              "name" : "apple A",
              "des" : "this is a apple A",
              "time" : "2001-03-01"
            }
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "2",
            "_score" : 1.0,
            "_source" : {
              "name" : "orange A",
              "des" : "this is a orange A",
              "time" : "2001-01-01"
            }
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "3",
            "_score" : 1.0,
            "_source" : {
              "name" : "orange B",
              "des" : "this is a orange B",
              "time" : "2001-05-01"
            }
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "4",
            "_score" : 1.0,
            "_source" : {
              "name" : "orange A B",
              "des" : "this is a orange A B",
              "time" : "2001-07-01"
            }
          }
        ]
      },
      "profile" : {
        "shards" : [
          {
            "id" : "[GiqyrgdeRXmHsb5T6U1N4Q][goods][0]",
            "searches" : [
              {
                "query" : [
                  {
                    "type" : "MatchAllDocsQuery",
                    "description" : "*:*",
                    "time_in_nanos" : 19159,
                    "breakdown" : {
                      "set_min_competitive_score_count" : 1,
                      "match_count" : 0,
                      "shallow_advance_count" : 0,
                      "set_min_competitive_score" : 1822,
                      "next_doc" : 2546,
                      "match" : 0,
                      "next_doc_count" : 6,
                      "score_count" : 4,
                      "compute_max_score_count" : 0,
                      "compute_max_score" : 0,
                      "advance" : 0,
                      "advance_count" : 0,
                      "score" : 904,
                      "build_scorer_count" : 2,
                      "create_weight" : 3046,
                      "shallow_advance" : 0,
                      "create_weight_count" : 1,
                      "build_scorer" : 10827
                    }
                  }
                ],
                "rewrite_time" : 1792,
                "collector" : [
                  {
                    "name" : "CancellableCollector",
                    "reason" : "search_cancelled",
                    "time_in_nanos" : 20735,
                    "children" : [
                      {
                        "name" : "SimpleTopScoreDocCollector",
                        "reason" : "search_top_hits",
                        "time_in_nanos" : 14405
                      }
                    ]
                  }
                ]
              }
            ],
            "aggregations" : [ ]
          }
        ]
      }
    }

### 2 排序 ###

\# 按日期倒叙排列  
post /goods/\_search  
\{  
  "sort":\[\{"time":"desc"\}\],  
  "query":\{  
    "match\_all":\{\}  
  \}  
\}

{
      "took" : 0,
      "timed_out" : false,
      "_shards" : {
        "total" : 1,
        "successful" : 1,
        "skipped" : 0,
        "failed" : 0
      },
      "hits" : {
        "total" : {
          "value" : 4,
          "relation" : "eq"
        },
        "max_score" : null,
        "hits" : [
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "4",
            "_score" : null,
            "_source" : {
              "name" : "orange A B",
              "des" : "this is a orange A B",
              "time" : "2001-07-01"
            },
            "sort" : [
              993945600000
            ]
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "3",
            "_score" : null,
            "_source" : {
              "name" : "orange B",
              "des" : "this is a orange B",
              "time" : "2001-05-01"
            },
            "sort" : [
              988675200000
            ]
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "1",
            "_score" : null,
            "_source" : {
              "name" : "apple A",
              "des" : "this is a apple A",
              "time" : "2001-03-01"
            },
            "sort" : [
              983404800000
            ]
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "2",
            "_score" : null,
            "_source" : {
              "name" : "orange A",
              "des" : "this is a orange A",
              "time" : "2001-01-01"
            },
            "sort" : [
              978307200000
            ]
          }
        ]
      }
    }

### 3 指定返回字段 ###

\# 只返回原始文档值的name  
post /goods/\_search  
\{  
  "\_source":\["name"\],  
  "query":\{  
    "match\_all":\{\}  
  \}  
\}

{
      "took" : 6,
      "timed_out" : false,
      "_shards" : {
        "total" : 1,
        "successful" : 1,
        "skipped" : 0,
        "failed" : 0
      },
      "hits" : {
        "total" : {
          "value" : 4,
          "relation" : "eq"
        },
        "max_score" : 1.0,
        "hits" : [
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "1",
            "_score" : 1.0,
            "_source" : {
              "name" : "apple A"
            }
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "2",
            "_score" : 1.0,
            "_source" : {
              "name" : "orange A"
            }
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "3",
            "_score" : 1.0,
            "_source" : {
              "name" : "orange B"
            }
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "4",
            "_score" : 1.0,
            "_source" : {
              "name" : "orange A B"
            }
          }
        ]
      }
    }

### 4 脚本字段 ###

\# time后面添加hello  
post /goods/\_search  
\{  
  "script\_fields":\{  
    "new\_field":\{  
      "script":\{  
        "lang":"painless",  
        "source":"doc\['time'\].value+'hello'"  
      \}  
    \}  
  \},  
  "query":\{  
    "match\_all": \{\}  
  \}  
\}

5 按词OR查询

\# 根据des字段查询 含有this 或者 b  
post /goods/\_search  
\{  
  "query":\{  
    "match":\{  
      "des":"this b"  
    \}  
  \}  
\}

{
      "took" : 1,
      "timed_out" : false,
      "_shards" : {
        "total" : 1,
        "successful" : 1,
        "skipped" : 0,
        "failed" : 0
      },
      "hits" : {
        "total" : {
          "value" : 4,
          "relation" : "eq"
        },
        "max_score" : 0.9778661,
        "hits" : [
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "3",
            "_score" : 0.9778661,
            "_source" : {
              "name" : "orange B",
              "des" : "this is a orange B",
              "time" : "2001-05-01"
            }
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "4",
            "_score" : 0.9054912,
            "_source" : {
              "name" : "orange A B",
              "des" : "this is a orange A B",
              "time" : "2001-07-01"
            }
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "1",
            "_score" : 0.08840232,
            "_source" : {
              "name" : "apple A",
              "des" : "this is a apple A",
              "time" : "2001-03-01"
            }
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "2",
            "_score" : 0.08840232,
            "_source" : {
              "name" : "orange A",
              "des" : "this is a orange A",
              "time" : "2001-01-01"
            }
          }
        ]
      }
    }

### 6 按词AND查询 ###

\# 根据des字段查询 含有this 且含有 b  
post /goods/\_search  
\{  
  "query":\{  
    "match": \{  
      "des": \{  
        "query":"this b",  
        "operator":"and"  
      \}  
    \}  
  \}  
\}

{
      "took" : 1,
      "timed_out" : false,
      "_shards" : {
        "total" : 1,
        "successful" : 1,
        "skipped" : 0,
        "failed" : 0
      },
      "hits" : {
        "total" : {
          "value" : 2,
          "relation" : "eq"
        },
        "max_score" : 0.9778661,
        "hits" : [
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "3",
            "_score" : 0.9778661,
            "_source" : {
              "name" : "orange B",
              "des" : "this is a orange B",
              "time" : "2001-05-01"
            }
          },
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "4",
            "_score" : 0.9054912,
            "_source" : {
              "name" : "orange A B",
              "des" : "this is a orange A B",
              "time" : "2001-07-01"
            }
          }
        ]
      }
    }

### 7 按词语查询 ###

\# 根据des字段查询 orange b这个词  
post /goods/\_search  
\{  
  "query":\{  
    "match\_phrase": \{  
      "des":\{  
        "query":"orange b"  
      \}  
    \}  
  \}  
\}

{
      "took" : 3,
      "timed_out" : false,
      "_shards" : {
        "total" : 1,
        "successful" : 1,
        "skipped" : 0,
        "failed" : 0
      },
      "hits" : {
        "total" : {
          "value" : 1,
          "relation" : "eq"
        },
        "max_score" : 1.1817447,
        "hits" : [
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "3",
            "_score" : 1.1817447,
            "_source" : {
              "name" : "orange B",
              "des" : "this is a orange B",
              "time" : "2001-05-01"
            }
          }
        ]
      }
    }

### 8 按词语查询 ###

\# 根据des字段查询 this apple这个词 中间允许隔2个词  
post /goods/\_search  
\{  
  "query":\{  
    "match\_phrase": \{  
      "des": \{  
        "query":"this apple",  
        "slop":2  
      \}  
    \}  
  \}  
\}

{
      "took" : 1,
      "timed_out" : false,
      "_shards" : {
        "total" : 1,
        "successful" : 1,
        "skipped" : 0,
        "failed" : 0
      },
      "hits" : {
        "total" : {
          "value" : 1,
          "relation" : "eq"
        },
        "max_score" : 0.720899,
        "hits" : [
          {
            "_index" : "goods",
            "_type" : "_doc",
            "_id" : "1",
            "_score" : 0.720899,
            "_source" : {
              "name" : "apple A",
              "des" : "this is a apple A",
              "time" : "2001-03-01"
            }
          }
        ]
      }
    }