0


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"
    }
  }
}

//不查询为空的数据
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的区别 - 护花使者 - 博客园


本文转载自: https://blog.csdn.net/talen_hx/article/details/122149092
版权归原作者 talen_hx296 所有, 如有侵权,请联系我们删除。

“es的query查询(term,prefix,exists,match,matchprase,range)”的评论:

还没有评论