ES7 - 多个字段sum之后倒序取前10

zhanghe687

于 2024-04-16 15:38:18 发布

阅读量153

点赞数 2

文章标签： java elasticsearch

本文链接：https://blog.csdn.net/zhanghe687/article/details/137827490

版权

本文介绍了如何在Elasticsearch中构建一个搜索请求，使用ScriptAPI对field1,field2,field3的值进行求和并按总和降序排序。示例代码展示了如何构造查询条件、Script对象以及排序过程。

摘要由CSDN通过智能技术生成

类似SQL: select sum(field1 + field2 + field3) as sum from table order by sum

SearchRequest searchRequest = new SearchRequest(索引);
            SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder().size(10);

            BoolQueryBuilder boolQueryBuilder = 这里构建查询条件


            // 创建一个script来求和三个字段
            Script script = new Script(
                    Script.DEFAULT_SCRIPT_TYPE,
                    Script.DEFAULT_SCRIPT_LANG,
                    "doc['field1'].value + doc['field2'].value + doc['field3'].value",
                    Collections.emptyMap()
            );

            // 添加script字段到source builder
            ScriptSortBuilder scriptSortBuilder = new ScriptSortBuilder(script, ScriptSortBuilder.ScriptSortType.NUMBER)
                    .order(SortOrder.DESC);

            // 添加 ScriptSortBuilder 到搜索源构建器
            searchSourceBuilder.query(boolQueryBuilder)
                    .fetchSource(new String[]{"id", "name", "sex"}, null)
                    .sort(scriptSortBuilder);

            searchRequest.source(searchSourceBuilder);
            SearchResponse response = clinet.search(searchRequest, RequestOptions.DEFAULT);
            SearchHit[] hits = response.getHits().getHits();