ES_DSL语法练习_

冷不防 2022-10-05 03:57 204阅读 0赞

#查看所有索引
    GET /_cat/indices?v
    
    #c创建索引
    PUT /shopping33
    
    #查看单个索引
    GET /shopping33
    
    #删除索引
    DELETE /shopping33
    
    #c创建索引
    PUT /shopping
    
    #创建文档
    POST /shopping/_doc
    { 
    "title":"小米手机",
    "category":"小米",
    "images":"http://www.gulixueyuan.com/xm.jpg",
    "price":3999.00
    }
    
    #创建文档,指定id
    POST /shopping/_doc/2
    { 
    "title":"华为手机",
    "category":"华为米",
    "images":"http://www.gulixueyuan.com/xm.jpg",
    "price":4999.00
    }
    
    #查看文档
    GET /shopping/_doc/2
    
    #修改文档,指定id
    POST /shopping/_doc/2
    { 
    "title":"华为手机",
    "category":"华为",
    "images":"http://www.gulixueyuan.com/xm.jpg",
    "price":6999.00
    }
    
    #仅修改某些字段
    POST /shopping/_update/2
    { 
    "doc": { 
    "price":3000.00
    }
    }
    
    POST /shopping/_doc/3
    { 
    "title":"小米手机",
    "category":"小米",
    "images":"http://www.gulixueyuan.com/xm.jpg",
    "price":4000.00
    }
    POST /shopping/_doc/4
    { 
    "title":"华为手机",
    "category":"华为",
    "images":"http://www.gulixueyuan.com/hw.jpg",
    "price":4000.00
    }
    
    #条件删除文档
    POST /shopping/_delete_by_query
    { 
      "query":{ 
        "match":{ 
          "price":4000.00
        }
      }
    }
    
    
    #创建映射
    DELETE /student
    
    #c创建索引
    PUT /student
    
    #创建映射
    POST /student/_mapping
    { 
    "properties": { 
    "name":{ 
    "type": "text",
    "index": true
    },
    "nickname":{ 
    "type": "text",
    "index": true
    },
    "sex":{ 
    "type": "text",
    "index": true
    },
    "age":{ 
    "type": "long",
    "index": true
    }
    }
    }
    
    #查看映射
    GET /student/_mapping
    
    #更新索引映射关联
    PUT /student
    { 
    "settings": { },
    "mappings": { 
    "properties": { 
    "name":{ 
    "type": "text",
    "index": true
    },
    "sex":{ 
    "type": "text",
    "index": true
    },
    "age":{ 
    "type": "long",
    "index": true
    }
    }
    }
    }
    
    POST /student/_doc/1001
    { 
    "name":"zhangsan",
    "nickname":"zhangsan",
    "sex":"男",
    "age":30
    }
    POST /student/_doc/1005
    { 
    "name":"zhangsan5",
    "nickname":"zhangsan",
    "sex":"男",
    "age":30
    }
    POST /student/_doc/1006
    { 
    "name":"zhangsan",
    "nickname":"zhangsan22",
    "sex":"男",
    "age":36
    }
    POST /student/_doc/1002
    { 
    "name":"lisi",
    "nickname":"lisi",
    "sex":"男",
    "age":20
    }
    POST /student/_doc/1003
    { 
    "name":"wangwu",
    "nickname":"wangwu",
    "sex":"女",
    "age":40
    }
    POST /student/_doc/1004
    { 
    "name":"zhangsan1",
    "nickname":"zhangsan1",
    "sex":"女",
    "age":50
    }
    POST /student/_doc/1005
    { 
    "name":"zhangsan2",
    "nickname":"zhangsan2",
    "sex":"女",
    "age":30
    }
    
    #查看所有文档
    GET /student/_search
    
    
    #查看所有文档
    GET /student/_search
    { 
    "query": { 
    "match_all": { }
    }
    }
    
    #匹配查询
    #match 匹配类型查询，会把查询条件进行分词，然后进行查询，多个词条之间是 or 的关系
    GET /student/_search
    { 
    "query": { 
    "match": { 
      "name": "zhangsan"
    }
    }
    }
    
    GET /student/_search
    { 
    "query": { 
    "match": { 
      "name": "zhang"
    }
    }
    }
    
    
    #字段匹配查询
    #multi_match 与 match 类似，不同的是它可以在多个字段中查询。
    GET /student/_search
    { 
    "query": { 
    "multi_match": { 
    "query": "zhangsan",
    "fields": ["name","nickname"]
    }
    }
    }
    
    #关键字精确查询
    #term 查询，精确的关键词匹配查询，不对查询条件进行分词。
    GET /student/_search
    { 
    "query": { 
    "term": { 
      "name": { 
        "value": "zhangsan"
      }
    }
    }
    }
    
    #多关键字精确查询
    #terms 查询和 term 查询一样，但它允许你指定多值进行匹配。
    
    GET /student/_search
    { 
    "query": { 
    "terms": { 
      "name": ["zhangsan","lisi"]
    }
    }
    }
    
    #指定查询字段
    #默认情况下， Elasticsearch 在搜索的结果中，会把文档中保存在_source 的所有字段都返回。
    #如果我们只想获取其中的部分字段，我们可以添加_source 的过滤
    GET /student/_search
    { 
      "_source": ["name","age"],
      "query": { 
        "terms": { 
          "nickname": [
            "zhangsan"
          ]
        }
      }
    }
    
    #过滤字段
    #includes：来指定想要显示的字段
    #excludes：来指定不想要显示的字段
    GET /student/_search
    { 
      "_source": { 
        "includes": ["name","age"]
      },
      "query": { 
        "terms": { 
          "nickname": [
            "zhangsan"
          ]
        }
      }
    }
    
    GET /student/_search
    { 
      "_source": { 
        "excludes": ["name","age"]
      },
      "query": { 
        "terms": { 
          "nickname": [
            "zhangsan"
          ]
        }
      }
    }
    
    #组合查询
    #`bool`把各种其它查询通过`must`（必须 ）、 `must_not`（必须不）、 `should`（应该）的方
    #式进行组合
    GET /student/_search
    { 
    "query": { 
    "bool": { 
    "must": [
    { 
    "match": { 
    "name": "zhangsan"
    }
    },
    { 
    "match": { 
    "nickname": "zhangsan"
    }
    }
    ],
    "must_not": [
    { 
    "match": { 
    "age": "36"
    }
    }
    ],
    "should": [
    { 
    "match": { 
    "sex": "女"
    }
    }
    ]
    }
    }
    }
    
    #范围查询
    #range 查询找出那些落在指定区间内的数字或者时间。 range 查询允许以下字符
    GET /student/_search
    { 
      "query": { 
        "range": { 
          "age": { 
            "gte": 10,
            "lte": 30
          }
        }
      }
    }
    
    
    #11) 单字段排序
    #sort 可以让我们按照不同的字段进行排序，并且通过 order 指定排序的方式。 desc 降序， asc
    #升序。
    GET /student/_search
    { 
      "query": { 
        "match": { 
          "name": "zhangsan"
        }
      },
      "sort": [
        { 
          "age": { 
            "order": "desc"
          }
        }
      ]
    }
    
    #多字段排序
    #假定我们想要结合使用 age 和 _score 进行查询，并且匹配的结果首先按照年龄排序，然后
    #按照相关性得分排序
    #注意排序字段不能是text等,一般都是Long
    GET /student/_search
    { 
      "query": { 
        "match_all": { }
      },
      "sort": [
        { 
          "_id": { 
            "order": "asc"
          }
        },
        { 
          "age": { 
            "order": "desc"
          }
        }
      ]
    }
    
    GET /student/_search
    { 
    "query": { 
    "match": { 
    "name": "zhangsan"
    }
    },
    "highlight": { 
    "pre_tags": "<font color='red'>",
    "post_tags": "</font>",
    "fields": { 
    "name": { }
    }
    }
    }
    
    #分页查询
    #from：当前页的起始索引，默认从 0 开始。 from = (pageNum - 1) * size
    #size：每页显示多少条
    GET /student/_search
    { 
      "query": { 
        "match_all": { }
      },
      "sort": [
        { 
          "_id": { 
            "order": "asc"
          }
        },
        { 
          "age": { 
            "order": "desc"
          }
        }
      ],
      "from": 2,
      "size": 2
      
    }
    
    #聚合查询
    #聚合允许使用者对 es 文档进行统计分析，类似与关系型数据库中的 group by，当然还有很
    #多其他的聚合，例如取最大值、平均值等等。
    #对某个字段取最大值 max
    GET /student/_search
    { 
    "aggs":{ 
    "max_age":{ 
    "max":{ "field":"age"}
    },
    "min_age":{ 
    "min":{ "field":"age"}
    },
    "sum_age":{ 
    "sum":{ "field":"age"}
    },
    "avg_age":{ 
    "avg":{ "field":"age"}
    }
    },
    "size":0
    }
    #State 聚合
    #stats 聚合，对某个字段一次性返回 count， max， min， avg 和 sum 五个指标
    GET /student/_search
    { 
    "aggs":{ 
    "stats_age":{ 
    "stats":{ "field":"age"}
    }
    },
    "size":0
    }
    
    #桶聚合查询
    #桶聚和相当于 sql 中的 group by 语句
    #terms 聚合，分组统计
    GET /student/_search
    { 
    "aggs":{ 
    "age_groupby":{ 
    "terms":{ "field":"age"}
    }
    },
    "size":0
    }
    #在 terms 分组下再进行聚合
    GET /student/_search
      { 
    "aggs":{ 
    "age_groupby":{ 
    "terms":{ "field":"age"}
    }
    },
    "size":0
    }