Elasticsearch使用filter进行匹配关系and,or,not,range查询

心已赠人 2023-05-28 05:20 29阅读 0赞

RESTful接口URL的格式：
    http://localhost:9200/<index>/<type>/[<id>]
    其中index、type是必须提供的。
    id是可选的，不提供es会自动生成。
    index、type将信息进行分层，利于管理。
    index可以理解为数据库；type理解为数据表；id相当于数据库表中记录的主键，是唯一的。
    
    
    #向store索引中添加一些书籍
    curl -XPUT 'http://172.16.0.14:9200/store/books/1' -d '{
      "title": "Elasticsearch: The Definitive Guide",
      "name" : {
        "first" : "Zachary",
        "last" : "Tong"
      },
      "publish_date":"2015-02-06",
      "price":"49.99"
    }'
    
    #通过浏览器查询
    http://172.16.0.14:9200/store/books/1
    
    #在linux中通过curl的方式查询
    curl -XGET 'http://172.16.0.14:9200/store/books/1'
    
    #在添加一个书的信息
    curl -XPUT 'http://172.16.0.14:9200/store/books/2' -d '{
      "title": "Elasticsearch Blueprints",
      "name" : {
        "first" : "Vineeth",
        "last" : "Mohan"
      },
      "publish_date":"2015-06-06",
      "price":"35.99"
    }'
    
    
    # 通过ID获得文档信息
    curl -XGET 'http://172.16.0.14:9200/bookstore/books/1'
    
    #在浏览器中查看
    http://172.16.0.14:9200/bookstore/books/1
    
    # 通过_source获取指定的字段
    curl -XGET 'http://172.16.0.14:9200/store/books/1?_source=title'
    curl -XGET 'http://172.16.0.14:9200/store/books/1?_source=title,price'
    curl -XGET 'http://172.16.0.14:9200/store/books/1?_source'
    
    #可以通过覆盖的方式更新
    curl -XPUT 'http://172.16.0.14:9200/store/books/1' -d '{
      "title": "Elasticsearch: The Definitive Guide",
      "name" : {
        "first" : "Zachary",
        "last" : "Tong"
      },
      "publish_date":"2016-02-06",
      "price":"99.99"
    }'
    
    # 或者通过 _update  API的方式单独更新你想要更新的
    curl -XPOST 'http://172.16.0.14:9200/store/books/1/_update' -d '{
      "doc": {
         "price" : 88.88
      }
    }'
    
    curl -XGET 'http://172.16.0.14:9200/store/books/1'
     
    #删除一个文档
    curl -XDELETE 'http://172.16.0.14:9200/store/books/1'
    
    
    # 最简单filter查询
    # SELECT * FROM books WHERE price = 35.99
    # filtered 查询价格是35.99的
    curl -XGET 'http://172.16.0.14:9200/store/books/_search' -d '{
        "query" : {
            "filtered" : {
                "query" : {
                    "match_all" : {}
                },
                "filter" : {
                    "term" : {
                        "price" : 35.99
                      }
                  }
            }
        }
    }'
    
    #指定多个值
    curl -XGET 'http://172.16.0.14:9200/store/books/_search' -d '{
        "query" : {
            "filtered" : {
                "filter" : {
                    "terms" : {
                        "price" : [35.99, 99.99]
                      }
                  }
            }
        }
    }'
    
    
    # SELECT * FROM books WHERE publish_date = "2015-02-06"
    curl -XGET 'http://172.16.0.14:9200/bookstore/books/_search' -d '{
      "query" : {
        "filtered" : {
            "filter" : {
               "term" : {
                  "publish_date" : "2015-02-06"
                }
              } 
          }
      }
    }'
    
    
    
    # bool过滤查询，可以做组合过滤查询
    # SELECT * FROM books WHERE (price = 35.99 OR price = 99.99) AND (publish_date != "2016-02-06")
    # 类似的，Elasticsearch也有 and, or, not这样的组合条件的查询方式
    # 格式如下：
    #  {
    #    "bool" : {
    #    "must" :     [],
    #    "should" :   [],
    #    "must_not" : [],
    #    }
    #  }
    #
    # must: 条件必须满足，相当于 and
    # should: 条件可以满足也可以不满足，相当于 or
    # must_not: 条件不需要满足，相当于 not
    
    curl -XGET 'http://172.16.0.14:9200/bookstore/books/_search' -d '{
      "query" : {
        "filtered" : {
          "filter" : {
            "bool" : {
              "should" : [
                { "term" : {"price" : 35.99}},
                { "term" : {"price" : 99.99}}
              ],
              "must_not" : {
                "term" : {"publish_date" : "2016-02-06"}
              }
            }
          }
        }
      }
    }'
    
    
    # 嵌套查询
    # SELECT * FROM books WHERE price = 35.99 OR ( publish_date = "2016-02-06" AND price = 99.99 )
    
    curl -XGET 'http://172.16.0.14:9200/bookstore/books/_search' -d '{
      "query" : {
        "filtered" : {
          "filter" : {
            "bool" : {
              "should" : [
                  { "term" : {"price" : 35.99}},
                  { "bool" : {
                  "must" : [
                    {"term" : {"publish_date" : "2016-02-06"}},
                    {"term" : {"price" : 99.99}}
                  ]
                }}
              ]
            }
          }
        }
      }
    }'
    
    # range范围过滤
    # SELECT * FROM books WHERE price >= 20 AND price < 100
    # gt :  > 大于
    # lt :  < 小于
    # gte :  >= 大于等于
    # lte :  <= 小于等于
    
    curl -XGET 'http://172.16.0.14:9200/store/books/_search' -d '{
      "query" : {
        "filtered" : {
          "filter" : {
            "range" : {
              "price" : {
                "gt" : 20.0,
                "lt" : 100
              }
            }
          }
        }
      }
    }'
    
    
    # 另外一种 and， or， not查询
    # 没有bool, 直接使用and , or , not
    # 注意: 不带bool的这种查询不能利用缓存
    # 查询价格既是35.99，publish_date又为"2015-02-06"的结果
    curl -XGET 'http://172.16.0.14:9200/bookstore/books/_search' -d '{
      "query": {
        "filtered": {
          "filter": {
            "and": [
            {
              "term": {
                "price":59.99
              }
            },
            {
              "term": {
                "publish_date":"2015-02-06"
              }
            }
           ]
         },
         "query": {
          "match_all": {}
          }
        }
      }
    }'

转载来自：[https://www.cnblogs.com/DreamDrive/p/6819449.html][https_www.cnblogs.com_DreamDrive_p_6819449.html]

[https_www.cnblogs.com_DreamDrive_p_6819449.html]: https://www.cnblogs.com/DreamDrive/p/6819449.html