弹性术语查询没有给出预期结果

Question

我有一个索引，其中我的每个对象都有状态字段，该字段可以有一些预定义的值。我想获取所有状态为“已启动”、“已更新”、“已删除”的查询，任何与这些匹配的，因此我使用Querybuilder和nativeSearchQuery，通过ElasticsearchOperations在控制台上打印的java创建了这个查询：

 {
  "bool" : {
    "must" : [
      {
        "terms" : {
          "status" : [
            "INITIATED",
            "UPDATED",
            "DELETED"
          ],
          "boost" : 1.0
        }
      }
    ],
    "adjust_pure_negative" : true,
    "boost" : 1.0
  }
}

我的索引中有“INITIATED”状态的数据，但没有得到查询中提到的任何状态的人。请如何修复此查询？如果您需要任何东西，请告诉我。

更新：添加代码

NativeSearchQueryBuilder nativeSearchQueryBuilder=new NativeSearchQueryBuilder();
QueryBuildersingleQb=QueryBuilders.boolQuery().must(QueryBuilders.termsQuery("status",statusList));
                                        
  Pageable pageable = PageRequest.of(0, 1, Sort.by(Defs.START_TIME).ascending());
                FieldSortBuilder sort = SortBuilders.fieldSort(Defs.START_TIME).order(SortOrder.ASC); 
  nativeSearchQueryBuilder.withQuery(singleQb);
  nativeSearchQueryBuilder.withSort(sort);
  nativeSearchQueryBuilder.withPageable(pageable);
                nativeSearchQueryBuilder.withIndices(Defs.SCHEDULED_MEETING_INDEX);
                nativeSearchQueryBuilder.withTypes(Defs.SCHEDULED_MEETING_INDEX);
    
 NativeSearchQuery searchQuery = nativeSearchQueryBuilder.build();
 List<ScheduledMeetingEntity> scheduledList=elasticsearchTemplate.queryForList(searchQuery, ScheduledMeetingEntity.class);

更新2：样本数据：

I got this from kibana query on this index:
 "hits" : [
      {
        "_index" : "index_name",
        "_type" : "type_name",
        "_id" : "1",
        "_score" : 1.0,
        "_source" : {
          "createTime" : "2021-03-03T13:09:59.198",
          "createTimeInMs" : 1614755399198,
          "createdBy" : "[e-mail]",
          "editTime" : "2021-03-03T13:09:59.198",
          "editTimeInMs" : 1614755399198,
          "editedBy" : "[e-mail]",
          "versionId" : 1,
          "id" : "1",
          "meetingId" : "47",
          "userId" : "129",
          "username" : "[e-mail]",
          "recipient" : [
            "[e-mail]"
          ],
          "subject" : "subject",
          "body" : "hi there",
          "startTime" : "2021-03-04T07:26:00.000",
          "endTime" : "2021-03-04T07:30:00.000",
          "meetingName" : "name123",
          "meetingPlace" : "placeName",
          "description" : "sfsafsdafsdf",
          "projectName" : "",
          "status" : "INITIATED",
          "failTry" : 0
        }
      }
    ]

Answer 1

确认映射：

GET/yourIndexName/\u映射

看看是否有效

您的映射需要有关键字才能使TermsQuery工作。

{
  "status": {
    "type" "text",
    "fields": {
      "keyword": {
        "type": "keyword",
        "ignore_above": 256
      }
    }
  }
}

当您第一次推送文档时，ES可以自动为您进行映射（无需您自己进行映射）。然而，如果你自己做映射，你可能有更好的控制。

无论哪种方式，都需要为状态字段定义关键字。

=============替代解决方案：（不区分大小写）

如果您有一个名为（状态）的字段，并且要搜索的值是（已启动、已更新或已删除）。

然后你可以这样做：

  BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery()
                .must(createStringSearchQuery());

public QueryBuilder createStringSearchQuery(){
            QueryStringQueryBuilder queryBuilder = QueryBuilders.queryStringQuery(" INITIATED OR UPDATED OR DELETED ");
            queryBuilder.defaultField("status");

     return queryBuilder;


}

打印QueryBuilder：

{
    "query_string" : {
      "query" : "INITIATED OR UPDATED OR DELETED",
      "default_field" : "status",
      "fields" : [ ],
      "type" : "best_fields",
      "default_operator" : "or",
      "max_determinized_states" : 10000,
      "enable_position_increments" : true,
      "fuzziness" : "AUTO",
      "fuzzy_prefix_length" : 0,
      "fuzzy_max_expansions" : 50,
      "phrase_slop" : 0,
      "escape" : false,
      "auto_generate_synonyms_phrase_query" : true,
      "fuzzy_transpositions" : true,
      "boost" : 1.0
    }
  }