(四)ElasticSearch7.X之聚合查询java代码（指定队伍的valueCount）

最新推荐文章于 2024-10-28 15:31:27 发布

国氏一雄

最新推荐文章于 2024-10-28 15:31:27 发布

阅读量1.6k

点赞数

CC 4.0 BY-SA版权

分类专栏：玩转elastisearch7.x（JAVA API）文章标签： elasticsearch

本文链接：https://blog.youkuaiyun.com/xiaohuo0930/article/details/107000178

玩转elastisearch7.x（JAVA API）专栏收录该内容

8 篇文章

订阅专栏

本文介绍了一种使用Elasticsearch查询特定NBA球队（如休斯顿火箭队）球员的年度统计数据的方法。通过构建精确的查询语句和聚合操作，可以统计出球队中球员的有效年度记录数量，为数据分析提供基础。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

valueCount：本field非空则+1

POST /nba/_search
{
    "query": {
    "term": {
    "teamNameEn.keyword": {
        "value": "Rockets"
        }
      }
},
"aggs": {
    "countPlayerYear": {
    "value_count": {
    "field": "playYear"
      }
    }
},
"size": 0
}

   @Test
    public void test03() throws IOException {
        SearchRequest searchRequest = new SearchRequest("nba");
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        //限定了查询的队伍名称
        searchSourceBuilder.query(QueryBuilders.termQuery("teamName.keyword","火箭")).size(100);
        ValueCountAggregationBuilder valueCountAggregationBuilder = AggregationBuilders.count("playYear").field("playYear");
        searchSourceBuilder.aggregation(valueCountAggregationBuilder);
        searchRequest.source(searchSourceBuilder);
        SearchResponse search = client.search(searchRequest, RequestOptions.DEFAULT);
        ValueCount valueCount = search.getAggregations().get("playYear");
        long value = valueCount.getValue();
        System.out.println(value);
    }