RestHighLevelClient 实现 select count from table group by filed

最新推荐文章于 2024-07-10 10:54:51 发布

停止使用此论坛

最新推荐文章于 2024-07-10 10:54:51 发布

阅读量7.5k

点赞数 1

分类专栏： elasticsearch

本文链接：https://blog.youkuaiyun.com/wangh92/article/details/82184952

版权

elasticsearch 专栏收录该内容

12 篇文章

订阅专栏

String id = null;
try {SearchRequest request = new SearchRequest(IndexAndTypeConstant.PROPERTY_SQL);
            request.types(IndexAndTypeConstant.PROPERTY_SQL_TYPE);

            SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
            searchSourceBuilder.size(0);
            request.source(searchSourceBuilder);

            TermsAggregationBuilder aggregationBuilder = AggregationBuilders.terms("estateIdAgg").field(PropertyIndexMappingConstant.ESTATE_ID);
            aggregationBuilder.order(BucketOrder.count(false));
            aggregationBuilder.size(Integer.MAX_VALUE);//todo
            searchSourceBuilder.aggregation(aggregationBuilder);
            SearchResponse searchResponse = client.search(request);
            Map<String, Aggregation> aggMap = searchResponse.getAggregations().getAsMap();
            ParsedStringTerms gradeTerms = (ParsedStringTerms) aggMap.get("estateIdAgg");
            List list = gradeTerms.getBuckets();
            for (Object object : list) {
                ParsedStringTerms.ParsedBucket obj = (ParsedStringTerms.ParsedBucket) object;
                String key = obj.getKeyAsString();
                long count = obj.getDocCount();
                id = key;
                UpdateRequest updateRequest = new UpdateRequest(IndexAndTypeConstant.SEARCH_INDEX,
                        IndexAndTypeConstant.SEARCH_TYPE, key)
                        .doc(jsonBuilder()
                                .startObject()
                                .field("count", count)
                                .endObject());
                client.update(updateRequest);
            }
        } catch (Exception e) {
           System.err.println("本条数据插入失败 id: " + id);
        }