首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >Spring data Elasticsearch按日期范围分组计数

问Spring data Elasticsearch按日期范围分组计数
EN

Stack Overflow用户
提问于 2020-12-07 07:08:37
回答 2查看 477关注 0票数 0

我使用了spring data elastic search,并且在elastic search中有一个this列表。

代码语言:javascript
复制
{"appUserId": "id-test-app-user11",   "apkId": 1,   "event": "INSTALL",  "date": "2020-06-01"}
...
{"appUserId": "id-test-app-user168",   "apkId": 1,   "event": "INSTALL",  "date": "2020-12-06"}

我想按天计算在某个日期范围内安装apkId的次数。

通过这个请求,我可以获得我的日期范围内的所有数据,并在参数中提供一个apkId

代码语言:javascript
复制
LocalDate today = LocalDate.now();                  
LocalDate beginningDate = today.minusDays(intervalle);

BoolQueryBuilder query = QueryBuilders.boolQuery();
query.must(QueryBuilders.rangeQuery("date") 
        .gte(convertToDateViaInstant(beginningDate))  
        .lte(convertToDateViaInstant(today)));
query.must(QueryBuilders.matchQuery("apkId", apkId));
query.must(QueryBuilders.matchQuery("event", Event.INSTALL));


return apkHistoryRepo.search(query);

但我不知道如何按日期进行汇总才能像这样

代码语言:javascript
复制
{"2020-06-01": "500"}
...
{"2020-12-06": "10"}

我怎么才能做到这一点呢?提前感谢

EN

回答 2

Stack Overflow用户

回答已采纳

发布于 2020-12-09 06:53:23

Java语言的最终解决方案

代码语言:javascript
复制
LocalDate today = LocalDate.now();                  
        LocalDate beginningDate = today.minusDays(intervalle);

        BoolQueryBuilder query = QueryBuilders.boolQuery();
        query.must(QueryBuilders.rangeQuery("date") 
                .gte(beginningDate)  
                .lte(today));
        query.must(QueryBuilders.matchQuery("apkId", apkId));
        query.must(QueryBuilders.matchQuery("event", Event.INSTALL));

        Iterable<ApkHistory> list = apkHistoryRepo.search(query);

        AggregationBuilder aggregation = AggregationBuilders
                .dateHistogram("nb_install_per_day")
                .field("date")
                .dateHistogramInterval(DateHistogramInterval.DAY);


        SearchRequest searchRequest = new SearchRequest("apkhistory"); 
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        searchSourceBuilder.query(query).aggregation(aggregation);
        searchRequest.source(searchSourceBuilder); 

        try {
            SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);

            ParsedDateHistogram dateGroupBy = searchResponse.getAggregations().get("nb_install_per_day");

        List<? extends Histogram.Bucket> bucketList = dateGroupBy.getBuckets();
        for(Bucket b : bucketList) {
            
            System.out.println(b.getKeyAsString() + " "+b.getDocCount());
            
        }
            System.out.println("test");
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
票数 0
EN

Stack Overflow用户

发布于 2020-12-07 11:17:48

您正在寻找date histogram聚合。下面是如何在查询中使用它,

代码语言:javascript
复制
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "apkId": "1"
          }
        },
        {
          "term": {
            "event": "INSTALL"
          }
        },
        {
          "range": {
            "date": {
              "gte": <start_date_here>,
              "lte": <end_date_here>
            }
          }
        }
      ]
    }
  },
  "aggs": {
    "per_day_count": {
      "date_histogram": {
        "field": "date",
        "calendar_interval": "1d"
      }
    }
  }
}
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/65174051

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档