es7.6.2 head 常用查询排序返回指定字段高亮查询指定多个字段检索时间区间查询 now函数 wildcard查询正则查询多条件bool查询

我就是我 2022-12-07 01:52 35阅读 0赞

基本查询 排序

[http://localhost:9200/suoyintest3/][http_localhost_9200_suoyintest3]

PSOT  \_search

\{  
  "query": \{  
    "match": \{  
      "content": "返回"  
    \}  
  \},  
  "sort": \{  
    "\_score": "desc"  
  \}  
\}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70][]

开启某个字段支持 fielddata 功能

[http://localhost:9200/suoyintest3/\_mapping/][http_localhost_9200_suoyintest3_mapping]

put

\{  
  "properties": \{  
    "title": \{  
      "type": "text",  
      "fielddata": true  
    \}  
  \}  
\}

然后根据 不存在这个字段的文档进行排序：

[http://localhost:9200/suoyintest3/][http_localhost_9200_suoyintest3 1]

post  \_search

\{  
  "query": \{  
    "match\_all": \{\}  
  \},  
  "sort": \[  
    \{  
      "content": \{  
        "order": "desc",  
        "missing": "\_last"  
      \}  
    \}  
  \]  
\}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 1][]

返回指定的字段，根据指定的字段排序，返回固定条数“”

[http://localhost:9200/suoyintest3/][http_localhost_9200_suoyintest3]

post \_search

\{  
  "query": \{  
    "match\_all": \{\}  
  \},  
  "sort": \{  
    "id": \{  
      "order": "desc"  
    \}  
  \},  
  "\_source": \[  
    "title",  
    "id"  
  \],  
  "size": 15  
\}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 2][]

高亮查询：

[http://localhost:9200/suoyintest3/][http_localhost_9200_suoyintest3]

post \_search

\{  
  "query": \{  
    "match": \{  
      "content": "接口"  
    \}  
  \},  
  "highlight": \{  
    "pre\_tags": \[  
      "<strong>"  
    \],  
    "post\_tags": \[  
      "</strong>"  
    \],  
    "fields": \{  
      "content": \{  
        "fragment\_size": 150,  
        "number\_of\_fragments": 1  
      \}  
    \}  
  \},  
  "size": 15  
\}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 3][]

指定多个字段检索：

[http://localhost:9200/suoyintest3/][http_localhost_9200_suoyintest3]

post  \_search

\{  
  "query": \{  
    "multi\_match": \{  
      "query": "通过",  
      "fields": \[  
        "title",  
        "content"  
      \]  
    \}  
  \}  
\}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 4][]

时间区间查询：

gte 大于等于

gt 大于

lte 小于等于

lt 小于

boost  权重 默认1.0

[http://localhost:9200/suoyintest3/][http_localhost_9200_suoyintest3]

put

先增加一个时间类型的 字段crtTime

\{  
  "properties": \{  
    "crtTime": \{  
      "type": "date"  
    \}  
  \}  
\}

再进行查询

\{  
  "query": \{  
    "range": \{  
      "crtTime": \{  
        "gt": "2020-09-01",  
        "lt": "2022-01-01"  
      \}  
    \}  
  \}  
\}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 5][]

也可以使用now  函数 和时间函数：例如 查询当前两天内的：**支持的单位有 y  M  w  d     h    H  m  s **

\{  
  "query": \{  
    "range": \{  
      "crtTime": \{  
        "gt": "now-2d",  
        "lt": "now"  
      \}  
    \}  
  \}  
\}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 6][]

模糊查询 wildcard 查询

支持\* 和？ \* 号表示任意多个任意字符，？ 代表任意一个字符

\{  
  "query": \{  
    "wildcard": \{  
      "title.keyword": \{  
        "value": "\*通过\*",  
        "boost": 10  
      \}  
    \}  
  \}  
\}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 7][]

\{  
  "query": \{  
    "wildcard": \{  
      "title.keyword": \{  
        "value": "集群健康状?，这是??",  
        "boost": 10  
      \}  
    \}  
  \}  
\}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 8][]

正则表达式查询：

\{  
  "query": \{  
    "regexp": \{  
      "title": \{  
        "value": "\[移动|菜鸟\]",  
        "boost": 10  
      \}  
    \}  
  \}  
\}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 9][]

多条件查询 bool:

\{  
  "query": \{  
    "bool": \{  
      "must": \{  
        "match": \{  
          "title": "移动"  
        \}  
      \},  
      "must\_not": \{  
        "match": \{  
          "title": "菜鸟"  
        \}  
      \}  
    \}  
  \}  
\}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 10][]

[http_localhost_9200_suoyintest3]: http://localhost:9200/suoyintest3/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70]: /images/20221123/987e449946964c59a3ab20e3d05de75c.png
[http_localhost_9200_suoyintest3_mapping]: http://localhost:9200/suoyintest3/_mapping/
[http_localhost_9200_suoyintest3 1]: http://localhost:9200/suoyintest3/_doc/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 1]: /images/20221123/da24ea738b6243cda4dcff3eefa21e15.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 2]: /images/20221123/846a9ac4f2f24e33a230989781051fcb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 3]: /images/20221123/e5f0b51699a74d57be8e0460b17eabf7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 4]: /images/20221123/5bd858fcd678486bae415e8b712db9d5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 5]: /images/20221123/fa19f2c3f97949caa58ef51192f6e3fb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 6]: /images/20221123/410cc64e1bcf4af88684e8ac480d002b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 7]: /images/20221123/1284c6ea37ae40d58d7d0a4984e77f9d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 8]: /images/20221123/b78b1f28aead4f168bd30fb3193bb104.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 9]: /images/20221123/661a21c1653944dd83dbb3f41114d428.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2Jvc3Nfd2F5_size_16_color_FFFFFF_t_70 10]: /images/20221123/7bdc909f4d6344b2bc72e429d5cfdd79.png