es的query查询(term,prefix,exists,match，matchprase,range)

//查询前缀包含的内容POST /products/_search{"query": {"prefix": {"desc.keyword": {"value": "iP"}}}}POST /products/_search{"query": {"term": {"productID.keyword": "XHDK-A-1293-#fJ3"}}}//不查询为空的数据.

talen_hx296

3581人浏览 · 2021-12-25 21:36:31

talen_hx296 · 2021-12-25 21:36:31 发布

//查询前缀包含的内容
POST /products/_search
{
  "query": {
    "prefix": {
      "desc.keyword": {
        "value": "iP"
      }
    }
  }
}

POST /products/_search
{
  "query": {
    "term": {
      "productID.keyword": "XHDK-A-1293-#fJ3"
    }
  }
}

//不查询为空的数据
POST /products/_search
{
  "query": {
    "exists": {
      "field": "desc"
    }
  }
}

The field in the source JSON is null or []
The field has "index" : false set in the mapping
The length of the field value exceeded an ignore_above setting in the mapping
The field value was malformed and ignore_malformed was defined in the mapping

//range query，区间查询
POST /products/_search
{
  "query": {
    "range": {
      "price": {
        "gte":100,
        "lte": 2000
      }
    }
  }
}

//使用match会分词
POST /products/_search
{
  "query": {
    "match": {
      "productID": "XHDK JODL"
    }
  }
}

POST /products/_search
{
  "query": {
    "term": {
      "desc": {
        "value":"iphone"
      }
    }
  }
}

es match、match_phrase、query_string和term的区别，可查看这链接

es match、match_phrase、query_string和term的区别 - 护花使者 - 博客园