What are the problems with mongodb highly aggregated queries?

problem description

aggregates data in a specified format into a specified format

related codes

{ 
    "_id" : "10.182.135.21_CPU_20180627200000", 
    "parameter" : {
        "CPUUtil" : [
            {
                "time" : ISODate("2018-06-27T12:07:19.000+0000"), 
                "value" : 15.0
            }, 
            {
                "time" : ISODate("2018-06-27T12:08:24.000+0000"), 
                "value" : 0.0
            }, 
            {
                "time" : ISODate("2018-06-27T12:09:29.000+0000"), 
                "value" : 0.0
            }
        ]
    }
}
{ 
    "_id" : "10.182.135.21_CPU_20180627210000", 
    "parameter" : {
        "CPUUtil" : [
            {
                "time" : ISODate("2018-06-27T13:07:01.000+0000"), 
                "value" : 0.0
            }, 
            {
                "time" : ISODate("2018-06-27T13:08:06.000+0000"), 
                "value" : 2.0
            }, 
            {
                "time" : ISODate("2018-06-27T13:09:11.000+0000"), 
                "value" : 0.0
            }
        ]
    }
}

what result do you expect? What is the error message actually seen?

first aggregate into an object, which contains two parameters "time" and "value", both of which are in the form of an array; secondly, convert the time format ISODate to the form of "yyyy-MM-DD HH:mm:ss"

{
    "time": [
        "2018-06-27 12:07:19",
        "2018-06-27 12:08:24",
        "2018-06-27 12:09:29",
        "2018-06-27 13:07:01",
        "2018-06-27 13:08:06",
        "2018-06-27 13:09:11"
    ],
    "value": [
        15.0,
        0.0,
        0.0,
        0.0,
        2.0,
        0.0
    ]
}
Feb.11,2022

</span>

:<br>{

"_id" : NumberInt(0),
"time" : [
    "2018-06-27 12:07:19", 
    "2018-06-27 12:08:24", 
    "2018-06-27 12:09:29", 
    "2018-06-27 13:07:01", 
    "2018-06-27 13:08:06", 
    "2018-06-27 13:09:11"
], 
"value" : [
    15.0, 
    0.0, 
    0.0, 
    0.0, 
    2.0, 
    0.0
]

}

Please do not hesitate to comment if you find a problem or have a better answer!

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b354e7-4050e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b354e7-4050e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?