ES查询相关

ES查询

匹配查询

GET /yitu_result/_search?size=1000
{
  "query": {
    "match": {
      "date":"2020070108"
    }
  }
}

结果过滤

GET /yitu_result/_search
{
  "query": {
    "match": {
      "date":"2020070108"
    }
  },
  "_source": ["face_image"]
}

结果排序

#聚合查询报错
Fielddata is disabled on text fields by default. Set fielddata=true on [title] in order to load fielddata in memory by uninverting the inverted index. Note that this can however use significant memory. Alternatively use a keyword field instead.

开启加载fielddata

PUT yitu_result/_mapping
{
  "properties": {
    "date": {
      "type":     "text",
      "fielddata": true
    }
  }
}

排序查询

GET /yitu_result/_search
{
  "query": {
    "match": {
      "date":"2020070108"
    }
  },
 "sort": [
   {
     "date": {
       "order": "desc"
     }
   }
 ]
}

分页查询

GET /yitu_result/_search
{
  "query": {
    "match": {
      "channel_floor": "06"
    }
  },
 "sort": [
   {
     "date": {
       "order": "desc"
     }
   }
 ],
 "from": 0, # 从第几页开始
 "size": 1  # 查询多少条数据
}

布尔值查询

must（所有条件都要符合）

GET yitu_result/_doc/_search
{
  "query":{
    "bool":{
      "must":[
        {
          "match":{
            "date":"2020070109"
          }    
        },
        {
          "match":{
            "channel_name":"06153"
          }
        }
      ]
    }
  }
}

should (or)，有一个匹配就行

GET yitu_result/_doc/_search
{
  "query":{
    "bool":{
      "should":[
        {
          "match":{
            "date":"2020070109"
          }    
        },
        {
          "match":{
            "date":"2020070108"
          }
        }
      ]
    }
  }
}

must_not 不必须，就是查询除这个以外的所有

GET yitu_result/_doc/_search
{
  "query":{
    "bool":{
      "must_not":[
        {
          "match":{
            "channel_name":"06153"
          }    
        }
      ]
    }
  }
}

过滤器filter

• gt 大于
• lt 小于
• gte 大于等于
• lte 小于等于

GET yitu_result/_doc/_search
{
  "query":{
    "bool":{
      "must":[
        {
          "match":{
            "channel_name":"06161"
          }    
        }
      ],
      "filter":{
        "range":{
# 有多个层级就一直点
"retrieval_results.similar_faces.similarity":{
            "gte":80
          }
        }
      }
    }
  }
}

多条件匹配查询

GET /yitu_result/_search
{
  "query": {
    "match": {
      "date": "2020070114 2020070111"
    }
  }
}

精确查询

term查询是直接通过倒排索引指定的词条进行精确查询

关于分词：

• term，直接查询精确的

• match,会使用分词器解析（先分析文档，然后再通过分析的文档进行查询）

  两个类型 text keyword

多个值匹配精确查询

高亮查询

GET /yitu_result/_search
{
  "query": {
    "match": {
      "date": "2020070114"
    }
  },
  "highlight": {
  	#自定义高亮格式
    "pre_tags": "<p class='key' style='color:red'>",
    "post_tags": "</p>", 
    "fields": {
      "date": {}
    }
  }
}

集成SpringBoot