弹性搜索脚本分数|无痛的查询

Question

我正在使用脚本查询，这是我想向社区提出的问题，我不太了解

这里是一个存储在弹性搜索中的示例JSON

{
        "_index" : "XXXXX",
        "_type" : "_doc",
        "_id" : "XXXX==",
        "_score" : 28.134966,
        "_source" : {
          "recruiter_id" : "XXXXX",
          "jobseeker_id" : "XXX",
          "profile_id" : "XXXXX",
          "isBlocked" : "",
          "isConnected" : "",
          "connection_time" : "2022-06-14 20:17:01",
          "status" : "pending",
          "isPending" : "True"
}

的查询

GET XXX/_search
{
   "query":{
      "function_score":{
         "query":{
        "match_all": {}
         },
         "script_score":{
            "script":{
              "lang": "painless", 
               "source":"""
                   double total = 0.0;
                   total = total + Math.log(doc['connection_time'].value.millis);
                  
                  return total;
               """
           
            }
         }
         
      }
      
   },
    "sort":[
      {
         "_score":"desc"
      }
   ]
 
}

，这是我编写 行或如果说明失败

  "script_score":{
            "script":{
              "lang": "painless", 
               "source":"""
                   double total = 0.0;
                   total = total + Math.log(doc['connection_time'].value.millis);
                   
                  if(doc['status'].value == 'accepted'){
                    total = total +100;
                  }
                  return total;
               """
           
            }
         }

错误，我遇到的是

 "org.elasticsearch.index.mapper.TextFieldMapper$TextFieldType.fielddataBuilder(TextFieldMapper.java:823)",
          "org.elasticsearch.index.fielddata.IndexFieldDataService.getForField(IndexFieldDataService.java:120)",
          "org.elasticsearch.index.query.QueryShardContext.lambda$lookup$1(QueryShardContext.java:328)",
          "org.elasticsearch.search.lookup.SearchLookup.lambda$new$1(SearchLookup.java:68)",
          "org.elasticsearch.search.lookup.LeafDocLookup$1.run(LeafDocLookup.java:95)",
          "org.elasticsearch.search.lookup.LeafDocLookup$1.run(LeafDocLookup.java:92)",
          "java.base/java.security.AccessController.doPrivileged(Native Method)",
          "org.elasticsearch.search.lookup.LeafDocLookup.get(LeafDocLookup.java:92)",
          "org.elasticsearch.search.lookup.LeafDocLookup.get(LeafDocLookup.java:40)",
          "if(doc['status'].value == 'accepted'){\n            

方案，那么似乎不会到达该字段

 "script_score":{
            "script":{
              "lang": "painless", 
               "source":"""
                   double total = 0.0;
                   total = total + Math.log(doc['connection_time'].value.millis);
                   
                  if(doc['status.keyword'].value == 'accepted'){
                    total = total +100;
                  }
                  return total;
               """
           
            }
         }

我所做的，我本质上将字段更改为关键字，但是如果有人可以指出问题并建议可能的解决

Answer 1

请尝试以下查询，您的查询都很好。我在系统上复制了您的方案，它可以正常工作。有关更多的许可，我参加了其他条件。可能是状态字段映射的问题，其中一些可能是给您这个错误的文本。

您的查询看起来像：