ElasticSearch filter查询

Love The Way You Lie 2023-07-17 12:49 75阅读 0赞

学习查询之前，我还是老规矩，先准备数据

#Filter查询
    #filter是不计算相关性的，同时可以cache.因此，filter速度要快于query.
    POST /lib5/items/_bulk
    {"index":{"_id": 1}}
    {"price": 40,"itemID": "ID100123"}
    {"index":{"_id": 2}}
    {"price": 50,"itemID": "ID100124"}
    {"index":{"_id": 3}}
    {"price": 25,"itemID": "ID100124"}
    {"index":{"_id": 4}}
    {"price": 30,"itemID": "ID100125"}
    {"index":{"_id":5}}
    {"price": null, "itemID": "ID100127"}

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70][]

查询价格为40的（过滤价格为40的数据）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70 1][]

查询价格25和40的

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70 3][]

## ** 注意：** ##

**我们post请求添加数据我用的是动态映射，自动创建的mapping，我们可以看下mapping**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70 4][]

## **注意：**我们看见了itemID是text类型 ，而text类型默认是进行分词的，分词的时候会将  "ID100123"  大写的字母转化成小写字母  "id100123" ##

我们将改成小写的试试，发现是ok的     如下图所示：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70 5][]

查询语句：

####2.8.1简单的过滤查询
    #term
    GET /lib5/items/_search
    { 
      "post_filter":{
        "term":{ "price":40}
      }
    } 
    
    #terms
    GET /lib5/items/_search
    {
      "post_filter":{
        "terms":{ "price": [25,40]}
      }  
    }
    
    GET /lib5/items/_search
    {
      "post_filter":{
        "term": { "itemID": "ID100123"}
      } 
    }

GET /lib5/items/_search
    {
      "query": {
        "bool": {
          "filter": [{ "term": { "price": 40}}]
        }
      }
    }
    
    GET /lib5/items/_search
    {
      "query": {
        "bool": {
          "filter": [{ 
            "terms": { "price": [25,40] }
          }]
        }
      }
    }
    
    GET /lib5/items/_search
    {
      "query": {
        "bool": {
          "filter": [{
            "term": { "itemID":"5100123" }
          }]
        }
      }
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70]: /images/20230528/64a58ed8b76f4a798b5787a4374cd56e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70 1]: /images/20230528/07fae0237b8f4527b58bc328d2da5292.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70 2]: /images/20230528/3b83fe7a50a14b5db2ef5b1d40f60f3a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70 3]: /images/20230528/3f955fe831a74b1c81c9e29a8cca780a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70 4]: /images/20230528/2d8a4fac63eb4973bc84a4eadf478abd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l3bDQ3MDgxMjA4Nw_size_16_color_FFFFFF_t_70 5]: /images/20230528/700d897c637c403ebc111eb66da8630e.png