Querying & Aggregations

Showing 47

Allow Pinning Query Plan Cache Key to a Fixed Plan for a Given Query Shape Hash

Allow Pinning Query Plan Cache Key to a Fixed Plan for a Given Query Shape Hash n MongoDB 8.0, the new setQuerySettings command allows administrators to enforce index hints and other behavior based on the query shape hash. This gives users partia...

Guest 3 months ago in Querying & Aggregations 0 Submitted

3 VOTE

Implement a $hash operator for queries

### Current State: MongoDB currently lacks a native `$hash` operator in the aggregation/query language. While certain helpers like `convertShardKeyToHashed` or `$toHashedIndexKey` exist, they are limited in scope: * Not available as true query o...

Guest 3 months ago in Querying & Aggregations 0 Submitted

21 VOTE

Add operator that would calculate distance between 2 geolocation points

It would be great to have operator that would calculate distance between 2 geolocation points, and not to do it manually with big aggregate queries. I suggest to add 2 new operators that would calculate distance in two different ways, as discuss...

Guest over 3 years ago in Querying & Aggregations 3 Submitted

35 VOTE

Allow configuration of 100mb memory limit per aggregation pipeline stage

In this old thread from 2016 (https://groups.google.com/forum/#!topic/mongodb-user/LCeFZZRz5EY) it was asked whether there was a way to increase the 100mb in memory limit of each stage of an aggregation pipeline. The responses centered around two ...

Guest over 5 years ago in Querying & Aggregations 2 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 8 months ago in Querying & Aggregations 0 Submitted

9 VOTE

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 almost 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 over 3 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

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 almost 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

Please enter your email address

FILTER BY CATEGORY