Mongo先分组再去重

db.bizEventReport2019.aggregate([
{$match:{event_id: "1002083", created_time: {"$gte":"2019-03-19 00:00:00", "$lte":"2019-03-20 23:59:59"}, app: "xyf"}}
,{$group:{_id:{"version_code":"$version_code","token": "$token"}}}
,{$group:{_id:{"version_code":"$_id.version_code"},"amount":{"$sum": 1}}}
,{$project:{"_id": 0, "version_code": "$_id.version_code", "amount": 1}}
])

命令执行后结果

posted @ 2019-03-27 11:26  yile  阅读(1032)  评论(0编辑  收藏  举报