废话不多说,看代码不明白留言,24小时在线为您服务!
DateFormat dateFormat2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date sd = dateFormat2.parse("2017-01-20"+" 11:37:00");
Date ed = dateFormat2.parse("2017-01-22"+" 00:00:00");
Aggregation agg = newAggregation(
Aggregation.match(Criteria.where("access_time").gte(sd).lte(ed)),
Aggregation.match(Criteria.where("access_url").is("http://www.baidu.com")),
Aggregation.project("access_urlll")
.and("access_url").as("access_url")
.and("created_date").as("created_date")
.and("dealStatus").as("dealStatus")
.and("request_method").as("request_method")
.and("data_type").as("data_type")
.andExpression("hour(created_date)").as("isohour"),
Aggregation.group("access_url","isohour","dealStatus","request_method","data_type").count().as("times"),
Aggregation.sort(Direction.DESC, "times")
);