Elasticsearch-terms搜索及结果优化

最新推荐文章于 2024-06-21 15:14:14 发布

BigMan-Hui

最新推荐文章于 2024-06-21 15:14:14 发布

阅读量1.5k

点赞数

分类专栏： elasticSearch 文章标签： elasticsearch

本文链接：https://blog.csdn.net/u011262847/article/details/77938495

版权

elasticSearch 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

测试数据：

POST /forum/article/_bulk
{ "index": { "_id": 1 }}
{ "articleID" : "XHDK-A-1293-#fJ3", "userID" : 1, "hidden": false, "postDate": "2017-01-01" }
{ "index": { "_id": 2 }}
{ "articleID" : "KDKE-B-9947-#kL5", "userID" : 1, "hidden": false, "postDate": "2017-01-02" }
{ "index": { "_id": 3 }}
{ "articleID" : "JODL-X-1937-#pV7", "userID" : 2, "hidden": false, "postDate": "2017-01-01" }
{ "index": { "_id": 4 }}
{ "articleID" : "QQPX-R-3956-#aD8", "userID" : 2, "hidden": true, "postDate": "2017-01-02" }

POST /forum/article/_bulk
{ "update": { "_id": "1"} }
{ "doc" : {"tag" : ["java", "hadoop"]} }
{ "update": { "_id": "2"} }
{ "doc" : {"tag" : ["java"]} }
{ "update": { "_id": "3"} }
{ "doc" : {"tag" : ["hadoop"]} }
{ "update": { "_id": "4"} }
{ "doc" : {"tag" : ["java", "elasticsearch"]} }

搜索articleID=KDKE-B-9947-#kL5或者QQPX-R-3956-#aD8的doc

GET /forum/article/_search
{
 "query": {
   "constant_score": {
     "filter": {
       "terms": {
         "articleID": [
           "KDKE-B-9947-#kL5",
           "QQPX-R-3956-#aD8"
         ]
       }
     }
   }
 }
}

搜索tags中有java的帖子

GET /forum/article/_search
{
  "query": {
    "constant_score": {
      "filter": {
        "terms": {
          "tag": ["java"]
        }
      }
    }
  }
}

对搜索到的结果进行优化，只想搜索到tag中只有java的doc：

POST /forum/article/_bulk
{ "update": { "_id": "1"} }
{ "doc" : {"tag_cnt" : 2} }
{ "update": { "_id": "2"} }
{ "doc" : {"tag_cnt" : 1} }
{ "update": { "_id": "3"} }
{ "doc" : {"tag_cnt" : 1} }
{ "update": { "_id": "4"} }
{ "doc" : {"tag_cnt" : 2} }

添加一个字段表示tag中的数量

GET /forum/article/_search
{
  "query": {
    "constant_score": {
      "filter": {
        "bool": {
          "must": [
            {
              "terms": {
                "tag": ["java"]
              }
            },
            {
              "term": {
                "tag_cnt": 1
              }
            }
          ]
        }
      }
    }
  }
}