elasticsearch 查询语法-Toy模板网

这篇具有很好参考价值的文章主要介绍了elasticsearch 查询语法。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

match_all 查询所有

GET test/_search
{
  "query": {
    "match_all": {}
  }
}

match 单字段匹配查询

GET test/_search
{
  "query":{
    "match":{
      "name":"zhangsan"
    }
  }
}

multi_match 多字段匹配查询

GET test/_search
{
  "query":{
    "match":{
      "name":"zhangsan"
    }
  }
}

term 关键字精确查询

GET test/_search
{
	"query": {
		"term": {
			"name": {
				"value": "zhangsan"
			}
		}
	}
}

terms 多关键字精确查询

GET test/_search
{
	"query": {
		"terms": {
			"status": {
				"value": [0,1,2,3]
			}
		}
	}
}

fuzzy 模糊匹配选择展示指定字段

GET test/_search
{
  "query": {
    "fuzzy": {
      "data": "好"
    }
  },
   "_source": ["name", "data"]
}

过滤字段
- includes：来指定想要显示的字段
- excludes：来指定不想要显示的字段

GET test/_search
{
  "query": {
    "terms": {
      "nickname": ["zhangsan"]
    }
  },
  "_source": {
    "includes": ["name","nickname"
    ]
  }
}

exists 查询字段age存在且id等于45的数据

GET /test/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "exists": {
            "field": "age"
          }
        },
        {
          "term": {
            "id": {
              "value": 45
            }
          }
        }
      ]
    }
  }
}

组合查询排序+分页

GET /test/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "terms": {
            "is_success": [1,2]
          }
        },
        {
          "term": {
            "deleted": 0
          }
        }
      ]
    }
  },
  "_source": ["_id","name","stage"],
  "sort": [
    {
      "customer_gmt_create_time": {
        "order": "asc"
      }
    }
  ],
  "from": 0,
  "size": 10
}

match_phrase_prefix 前缀查询

GET test/_search
{
  "query": {
    "match_phrase_prefix": {
      "name": "wang"
    }
  }
}

指定id批量查询

GET test/_search
{
  "query": {
    "ids": {
      "values": ["66606794","66606795"]
    }
  }
}

组合查询（range+should）

GET test/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "range": {
            "create_time": {
              "gte": "2017-12-25 01:25:10",
              "lte": "2017-12-25 12:10:36"
            }
          }
        },
        {
          "bool": {
            "should": [
              {
                "term": {
                  "name": {
                    "value": "zhangsan"
                  }
                }
              },
              {
                "term": {
                  "age": {
                    "value": 7
                  }
                }
              }
            ]
          }
        }
      ]
    }
  },
  "_source": ["alarm_name","alarm_time","alarm_type","info"],
  "sort": [
    {
      "customer_gmt_create_time": {
        "order": "asc"
      }
    }
  ],
  "from": 0,
  "size": 10
}