【大数据】elasticsearch进阶查询

#全部查询  按照年龄降序排序  分页 =>limit 0,5
GET bank/_search
{
  "query": {
    "match_all": {}
  },
  "sort": [
    {
      "balance": {
        "order": "desc"
      }
    }
  ],
  "from": 0,
  "size": 5
}


#_source 查看部分字段 
GET bank/_search
{
  "query": {
    "match_all": {}
  },
  "sort": [
    {
      "balance": {
        "order": "desc"
      }
    }
  ],
  "from": 0,
  "size": 5,
  "_source":["balance","age","firstname"]
}

#match  匹配查询
GET bank/_search
{
  "query": {
    "match": {
      "address": "mill lane"
    }
  }
}

#match_phrase 不可分割 短语查询
GET bank/_search
{
  "query": {
    "match_phrase": {
      "address": "mill lane"
    }
  }
}

#multi_match 多字段查询  指定字段中出现了目标文本都行
GET bank/_search
{
  "query": {
    "multi_match": {
      "query": "mill",
      "fields": ["address","email","city"]
    }
  }
}

#bool 复合查询  性别必须是女,地址包含mill,年龄不等于38
GET bank/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "gender": "M"
          }
        },
        {
          "match": {
            "address": "mill"
          }
        }
      ],
      "must_not": [
        {
          "match": {
            "age": 38
          }
        }
      ]
    }
  }
}

#should 应该可能的意思。顾名思义，满足的话最好，不满足也没事
GET bank/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "gender": "M"
          }
        },
        {
          "match": {
            "address": "mill"
          }
        }
      ],
      "should": [
        {"match": {
          "city": "Blackgum"
        }}
      ]
    }
  }
}

#filter 用法与must 一致， 区别在于 filter没有参与评分
GET bank/_search
{
  "query": {
    "bool": {
      "filter": [
        {
          "match": {
            "gender": "M"
          }
        },
        {
          "match": {
            "address": "mill"
          }
        }
      ]
    }
  }
}