ElasticSearch6.x 之词项查询

ゞ浴缸里的玫瑰 2024-02-19 21:16 62阅读 0赞

词项查询：通常用于数字，日期和枚举等结构化数据，而不是全文本字段。

词项查询之rang查询

range查询用于匹配数值型、日期型或字符串型字段在某一范围内的文档。

示例：

创建my\_index,初始化相关数据：

PUT my-index
    
    PUT my-index/doc/1
    {"age":12}
    
    PUT my-index/doc/2
    {"age":18}
    
    PUT my-index/doc/3
    {"age":21}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70][]

GET  http://192.168.1.74:9200/my_index/doc/_search/
    {
     "query": {
            "range" : {
                "age" : {
                    "gte" : 10,
                    "lte" : 20
                }
            }
        }
    }

示例：日期范围查询

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 1][]

http://192.168.1.74:9200/website/blog/_search/
    {
     "query": {
            "range" : {
                "postdate" : {
                    "gte" : "2017-01-01",
                    "lte" :  "2017-12-31",
                    "format": "yyyy-MM-dd"
                }
            }
    
        }
    }

词项查询之exists查询

返回字段中至少包含一个非空值的文档.

创建my\_index,初始化相关数据：

PUT my-index
    
    PUT my-index/doc/1
    { "user": "jane" }
    
    PUT my-index/doc/2
    { "user": "" }
    
    PUT my-index/doc/3
    { "user": [] }
    
    PUT my-index/doc/4
    { "user": ["jane", null ] }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 2][]

http://192.168.1.74:9200/my_index/doc/_search/
    {
    "query": {
            "exists" : { "field" : "user" }
        }
    }

词项查询之prefix查询（前缀查询）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 3][]

http://192.168.1.74:9200/my_index/doc/_search/
    {
    "query": {
           "prefix" : { "user" : "j"}
        }
    }

词项查询之wildcard查询（通配符查询）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 4][]

http://192.168.1.74:9200/website/blog/_search/
    {
    "query": {
           "wildcard" : { "title" : "*之*" }
        }
    }

词项查询之regexp查询（正则查询）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 5][]

http://192.168.1.74:9200/website/blog/_search/
    {
    "query": {
           "regexp":{
                "title": "黑白"
            }
        }
    }

词项查询之fuzzy查询（模糊查询）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 6][]

http://192.168.1.74:9200/website/blog/_search/
    {
    "query": {
           "fuzzy":{
                "title": "Spring"
            }
        }
    }

词项查询之type查询（类型查询）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 7][]

http://192.168.1.74:9200/website/blog/_search/
    {
    "query": {
           "type" : {
                "value" : "blog"
            }
        }
    }

词项查询之ids查询

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 8][]

http://192.168.1.74:9200/website/_search/
    {
    "query": {
           "ids" : {
                "type" : "blog",
                "values" : ["2", "3"]
            }
        }
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/bbaca731bfad4a2785f26c5b03b57861.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/29509f2f7e5c4ed5af348446895f3dc5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/3327797b46ec42dfb3410f28453e6371.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/1a95ae9382e4459c8964102de9c527bd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 4]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/19ee4dd3fa4e4a98bad78b063e14b051.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 5]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/f152ce8cfc2946f9a115b10a57d3fd95.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 6]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/a407117670674849bd237ceacb575c2d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 7]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/d7ac4d99c8d94a3b9c445696e73e1698.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70 8]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/7191d9df7d3043bf9bca166b16e203eb.png