使用ElasticSearch Template调用withQuery报缺少Builder.<variant kind>属性异常

异常原因 #

问题出在nativeQueryBuilder.withQuery方法内的bool查询构建逻辑：当传入的category和subcategory都为null时，mustBuilder没有添加任何term条件就直接返回，导致构建的bool查询缺少有效子句。ElasticSearch的查询构建器要求每个逻辑子句（如must）必须包含至少一个有效查询节点，空的子句会触发该必填属性缺失异常。

解决方法 #

核心是避免构建空的must子句，同时保证查询结构合法，以下两种方案可修复问题：

方案1：无有效条件时使用match_all查询 #

先检查是否有至少一个非空过滤条件，若没有则返回match_all查询，确保查询结构有效：

public void getMaxMinPrice(String category, String subcategory) {
    var nativeQueryBuilder = new NativeQueryBuilder();

    nativeQueryBuilder.withQuery(queryBuilder -> {
        BoolQuery.Builder boolBuilder = queryBuilder.bool();
        MustQuery.Builder mustBuilder = boolBuilder.must();
        boolean hasValidConditions = false;

        if (category != null) {
            mustBuilder.term(termBuilder -> termBuilder.field("category.keyword").value(category));
            hasValidConditions = true;
        }

        if (subcategory != null) {
            mustBuilder.term(termBuilder -> termBuilder.field("subcategory.keyword").value(subcategory));
            hasValidConditions = true;
        }

        // 无有效条件时返回match_all查询
        if (!hasValidConditions) {
            return queryBuilder.matchAll(matchAll -> matchAll).build()._toQuery();
        }

        return boolBuilder.build()._toQuery();
    });

    nativeQueryBuilder.withAggregation("max_price", Aggregation.of(aggBuilder ->
            aggBuilder.max(maxBuilder -> maxBuilder.field("price"))));

    nativeQueryBuilder.withAggregation("min_price", Aggregation.of(aggBuilder ->
            aggBuilder.min(minBuilder -> minBuilder.field("price"))));
}

方案2：仅当有条件时添加must子句 #

如果业务允许无过滤条件时不添加must子句，可调整bool查询的构建逻辑，只在有条件时生成must子句：

public void getMaxMinPrice(String category, String subcategory) {
    var nativeQueryBuilder = new NativeQueryBuilder();

    nativeQueryBuilder.withQuery(queryBuilder -> {
        BoolQuery.Builder boolBuilder = queryBuilder.bool();

        if (category != null || subcategory != null) {
            MustQuery.Builder mustBuilder = boolBuilder.must();
            if (category != null) {
                mustBuilder.term(termBuilder -> termBuilder.field("category.keyword").value(category));
            }
            if (subcategory != null) {
                mustBuilder.term(termBuilder -> termBuilder.field("subcategory.keyword").value(subcategory));
            }
        }

        return boolBuilder.build()._toQuery();
    });

    nativeQueryBuilder.withAggregation("max_price", Aggregation.of(aggBuilder ->
            aggBuilder.max(maxBuilder -> maxBuilder.field("price"))));

    nativeQueryBuilder.withAggregation("min_price", Aggregation.of(aggBuilder ->
            aggBuilder.min(minBuilder -> minBuilder.field("price"))));
}

这种方式下，无过滤条件时的bool查询等价于match_all查询，同样能避免异常触发。

内容的提问来源于stack exchange，提问作者Binary