MongoDB聚合分组后timeStamp数组排序异常问题咨询

Hey there, let's break down why your timestamp arrays aren't sorting properly for some ifsIndex groups, and fix it up!

What's Wrong With Your Current Query? #

Your existing aggregation uses $sort after the $group stage, but that only sorts the entire list of grouped documents (like arranging which group comes first in the results). It doesn't do anything to sort the individual timeStamp arrays inside each group.

The $push operator just adds values to the array in the order the original documents are processed by the $group stage. If those original documents aren't sorted by timeStamp before grouping, the array will end up in a random order—this is exactly why some of your arrays look unsorted.

Fix 1: Sort Before Grouping (Works for All MongoDB Versions) #

The simplest fix is to sort your documents before grouping them. Since MongoDB preserves the order of documents when using $push after a $sort, this ensures your timeStamp arrays are built in ascending order right from the start.

Here's the corrected query:

db.events.aggregate([
  // First, sort by ip, ifsIndex, and timeStamp to ensure proper order for grouping
  {$sort: {"ip": 1, "ifsIndex": 1, "timeStamp": 1}},
  // Now group—push will add values in the sorted order
  {$group: {
    _id: {"ifIndex": "$ifsIndex", "ip": "$ip"},
    status: {$push: "$link"},
    timeStamp: {$push: "$timeStamp"}
  }}
])

Fix 2: Use $sortArray (MongoDB 5.0+) #

If you're using MongoDB 5.0 or later, you can use the $sortArray operator directly on the grouped arrays to sort them after grouping. This is handy if you don't want to sort the entire collection first:

db.events.aggregate([
  {$group: {
    _id: {"ifIndex": "$ifsIndex", "ip": "$ip"},
    status: {$push: "$link"},
    timeStamp: {$push: "$timeStamp"}
  }},
  // Sort the timeStamp array inside each group
  {$set: {
    timeStamp: {$sortArray: {input: "$timeStamp", sortBy: 1}}
  }}
])

Either approach will ensure all your timeStamp arrays are properly sorted, regardless of the ifsIndex value.

内容的提问来源于stack exchange，提问作者Rahul Sawant