mongodb 聚合查询每天论坛链接点击次数

最新推荐文章于 2021-06-26 09:29:50 发布

iteye_13003

最新推荐文章于 2021-06-26 09:29:50 发布

阅读量331

点赞数

分类专栏： mongodb 文章标签：乔乐共享纵观千象每天进步一点点学习永无止境 mongodb

本文链接：https://blog.csdn.net/iteye_13003/article/details/82637320

版权

mongodb 专栏收录该内容

5 篇文章 1 订阅

订阅专栏

/* 18 */
{
    "_id" : ObjectId("5596414cbe4d73a327e50274"),
    "msgType" : "text",
    "sendTime" : ISODate("2015-07-03T08:01:16.000Z")
}

/* 19 */
{
    "_id" : ObjectId("5596414cbe4d73a327e50275"),
    "msgType" : "text",
    "sendTime" : ISODate("2015-07-03T08:01:16.000Z")
}

/* 20 */
{
    "_id" : ObjectId("55964179a29582f427335cff"),
    "msgType" : "text",
    "sendTime" : ISODate("2015-07-03T08:02:01.000Z")
}

/* 21 */
{
    "_id" : ObjectId("559641aba29582f427335d01"),
    "msgType" : "text",
    "sendTime" : ISODate("2015-07-03T08:02:51.000Z")
}

/* 22 */
{
    "_id" : ObjectId("553ae47bd1ba636729be4106"),
    "msgType" : "text",
    "sendTime" : ISODate("2015-04-25T00:48:59.000Z")
}


// Group Sql here
db.getCollection('wechat_message').aggregate(
    [         
        {   $group   : { _id : {$dayOfYear: "$sendTime"},  click : { $sum : 1 }}},
        {   $sort    : { _id : -1 }}        
    ]
)


// Result here
{
            "_id" : 178,
            "click" : 8.0000000000000000
        }, 
        {
            "_id" : 177,
            "click" : 21.0000000000000000
        }, 
        {
            "_id" : 176,
            "click" : 32.0000000000000000
        }, 
        {
            "_id" : 175,
            "click" : 16.0000000000000000
        }, 
        {
            "_id" : 174,
            "click" : 8.0000000000000000
        }, 
        {
            "_id" : 173,
            "click" : 7.0000000000000000
        }, 
        {
            "_id" : 172,
            "click" : 8.0000000000000000
        },