数据分组:
db.raw_data.aggregate([
{$group: {"_id": "$articleNo", "count":{$sum:1}}}
])
结果:_id是分组的字段值,count是每一个值的总数
java代码:
包:spring-data-mongodb-2.1.4.RELEASE.jar
Aggregation aggregation = Aggregation.newAggregation(
Aggregation.match(criteria),// 条件
Aggregation.group("articleNo").count().as("count")// 分组统计
);
AggregationResults<JSONObject> result = mongoTemplate.aggregate(aggregation, "raw_data",JSONObject.class);
List<JSONObject> list= result.getMappedResults();
结果是:[{
"_id":"526215",
"count":"3"
}]
多重分组
db.raw_data.aggregate([
{$grou