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

NBA球员年度统计

最新推荐文章于 2024-12-03 22:48:53 发布

原创最新推荐文章于 2024-12-03 22:48:53 发布 · 1.6k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#elasticsearch

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

8 篇文章

订阅专栏

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

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);
    }