这可能是一个远景，但是:

This is probably a longshot, but:

我想按日期之间的间隔对一组时间序列文档进行分组:按日期升序对文档进行排序，然后在当前文档与上一个文档之间的间隔超过某个阈值时进行分区.

I'd like to group a set of time-series documents by gaps between dates: sort the documents ascending by date, then partition when the interval between the current and previous is above some threshold.

当然，在获得文件后，我可以轻松地做到这一点；在此示例中，原始文档将获得一个新的分区号字段:

I can do this easily after getting the documents, of course; in this example, the original documents get a new partition number field:

但是我实际上并不需要文档，我只需要每个分区的起止日期和文档数量.尚不清楚我将如何执行分区功能.

But I don't actually need the documents themselves, I just need the first and last dates and number of docs for each partition. It's just unclear how I would do the partitioning function.

使用汇总有可能吗?我看到一个可能相关的Mondo票证已经打开，所以我猜没有.

Is this possible with an aggregation? I see a possibly relevant Mondo ticket that is open, so I'm guessing not.

是的，有可能.要比较多个文档，您需要使用 $组，然后将null作为_id传递.然后，要开始比较值，就需要像for循环一样的索引，以便可以使用 $ range 运算符.

Yes, it is possible. To compare multiple documents you need to put them in one array using $group and passing null as _id. Then to start comparing values you need an index just like in for loop so you can generate it using $range operator.

要确定分区，您需要加倍 $ map .第一个将返回一个0和1值的数组，其中1表示该日期开始新分区.

To determine partitions you need double $map. First one will return an array of 0 and 1 values where 1 means that this date starts new partition.

第二个$map将日期与分区索引合并.要获取分区索引，您可以 $ sum 和零和一的子数组( $ slice ).

Second $map is to merge dates with partition indexes. To get the partition index you can $sum an subarray ($slice) of zeros and ones.

例如:

在20分钟的间隔内，您可以在汇总以下运行:

For the interval of 20 minutes you can run below aggregation:

哪个将打印:

MongoDB游乐场