Querying & Aggregations

Showing 53 of 3991

Handle Daylight Saving Time when $densify is used on a date field

When using "day" as "unit" for a $densify pipeline stage on a date field, the date is always advanced of 24 hours. This is however not always the expected result in timezones in which the year has one 23-hour and one 25-hour long day, because of D...

Guest about 3 years ago in Querying & Aggregations 1 Submitted

11 VOTE

Raise the limit of 16 MB JSON between aggregation stages

When doing analytics, the 16 MB JSON limit between aggregation stages restricts the ability to process large amount of data. allowDiskUse does not help with all the various $operators and stages that we use. See ticket 00774514 for details.

Guest almost 4 years ago in Querying & Aggregations 0 Submitted

11 VOTE

geoContain

Dear all, according to the attached image, I have some documents (in blue, with id from 1 to 5) having a geographic extent and a search area (in yellow). I need to find all documents where search area is completly inside the document's geometry. U...

Guest over 4 years ago in Querying & Aggregations 0 Submitted

2 VOTE

Leveraging Group By/Distinct Query to use regular Index

When using Group By or Distinct queries on database, provide the ability to leverage existing index i.e these queries today will miss using existing index db.collection.distinct("field") db.collection.aggregate([ { $group: { _id: "$category", ...

Guest 11 months ago in Querying & Aggregations 0 Submitted

6 VOTE

Support compound/multiple grouping keys in $bucket

We often need to compute statistical/summarizing aggregations grouped by more than one field where all fields are of a $bucket-able type. An example, would be to count all orders grouped by their status and some custom time ranges of their creati...

Guest about 3 years ago in Querying & Aggregations 0 Submitted

6 VOTE

`$getField` to work with a dynamic `field`

Currently `$getField` works only when `field` resolves at query-compile-time to a string. It would be nice if it worked also when `field` resolves to a string at *runtime*. See this Jira ticket - https://jira.mongodb.org/browse/SERVER-67030

Guest over 3 years ago in Querying & Aggregations 0 Submitted

3 VOTE

support parallel query executions include find(), aggregation()

To use multi-core environment and enhance the query performance w/ a large amount of documents, need a parallel execution. Sharding or microsharding is not an alternative in this case.

Guest about 2 years ago in Querying & Aggregations 0 Submitted

3 VOTE

define the random seed manually, for $rand and $sample

It will be great if an additional paramater to define the seed for $rand and $sample could be use.

Guest over 2 years ago in Querying & Aggregations 1 Submitted

2 VOTE

Make $merge support DELETE operation

Currently, the `$merge` only supports insert/update/upsert/merge behaviour. It would be great to support delete behaviour. A common use case would be in-place document deduplication/clean-up in a collection.

Guest almost 2 years ago in Querying & Aggregations 0 Submitted

3 VOTE

$merge

Report number of docs matched, merged, skipped, etc. from a $merge stage. Alternatively, return the merged doc results as a pipeline result to pass to additional stages.

Charlie Little almost 3 years ago in Querying & Aggregations 0 Submitted

Please enter your email address

FILTER BY CATEGORY