mongodb - Mongo DB 聚合管道

Question

我是 Mango DB 的新手，任何人都可以解释如何在单个查询结果中从中获取以下统计信息

• 它由“lastActionTimestamp”分组
• 我们应该得到“extractionFinished”、“transformationFinished”、“loadFinished”、failed 和 status=duplicate 文档的总数。有人可以帮忙吗？

样本数据集：

   "migration" : {
            "sourceSystem" : "Test",
            "targetSystem" : "Test2",
            "lastAction" : "load finished",
            "lastActionTimestamp" : ISODate("2018-04-28T19:08:00.335Z"),
            "extractionStarted" : ISODate("2018-04-14T02:22:46.882Z"),
            "extractionFinished" : ISODate("2018-04-14T02:22:46.882Z"),
            "failed" : false
            "status" : "Valid",
            "deltaStatus" : false,
            "transformationStarted" : ISODate("2018-04-22T14:33:46.020Z"),
            "transformationFinished" : ISODate("2018-04-22T14:33:46.023Z"),
            "loadStarted" : ISODate("2018-04-28T19:07:58.803Z"),
            "loadFinished" : ISODate("2018-04-28T19:08:00.336Z"),
            "failureReason" : ""
        }

        "migration" : {
            "sourceSystem" : "Test",
            "targetSystem" : "Test2",
            "lastAction" : "load finished",
            "lastActionTimestamp" : ISODate("2018-04-28T19:08:00.335Z"),
            "extractionStarted" : ISODate("2018-04-14T02:22:46.882Z"),
            "extractionFinished" : ISODate("2018-04-14T02:22:46.882Z"),
            "failed" : true
            "status" : "Valid",
            "deltaStatus" : false,
            "transformationStarted" : ISODate("2018-04-22T14:33:46.020Z"),
            "transformationFinished" : ISODate("2018-04-22T14:33:46.023Z"),

            "failureReason" : "Some Issue"
        }
        "migration" : {
            "sourceSystem" : "Test",
            "targetSystem" : "Test2",
            "lastAction" : "load finished",
            "lastActionTimestamp" : ISODate("2018-04-28T19:08:00.335Z"),
            "extractionStarted" : ISODate("2018-04-14T02:22:46.882Z"),
            "extractionFinished" : ISODate("2018-04-14T02:22:46.882Z"),
            "failed" : False
            "status" : "Duplicate",
            "deltaStatus" : false,
            "transformationStarted" : ISODate("2018-04-22T14:33:46.020Z"),
            "transformationFinished" : ISODate("2018-04-22T14:33:46.023Z"),

            "failureReason" : ""
        }

预期输出：

提取完成：3 转换完成：3 加载完成：1 重复：1 失败：1

标签： mongodbaggregation-framework