Querying & Aggregations

Is there any limitation on size of query in pipeline (character in query, not data)

I have an aggregate query, when the character in pipeline over 21066 character, the result return wrong format that the pipeline expected. So I wonder is there any limitation on size of query in pipeline? My case is: Query: [ "$match":{"profileI...

Guest about 2 years ago in Querying & Aggregations 0 Submitted

2 VOTE

hint support for $graphLookup

Currently you can supply a `hint` to the `aggregation` call in order to tell MongoDB to use a specific index for the initial `$match`. But there is currently no way to specify which index to use for a `$graphLookup` later in the pipeline. I would...

Guest about 4 years ago in Querying & Aggregations 0 Submitted

1 VOTE

Support concise correlated queries for $graphLookUp

Similar to $lookUp, support concise correlated queries for $graphLookUp. It would allow adding a $project stage to reduce overhead.

Guest about 2 years ago in Querying & Aggregations 0 Submitted

1 VOTE

$sort should allow 0 as argument meaning "no sort"

The $sort operator and aggregation stage should allow 0 (possibly also null) as an argument for the field sort order, meaning, "Don't sort." This allows a variable to be passed in that can conditionally skip the sort operation, in addition to the ...

Guest about 2 years ago in Querying & Aggregations 0 Submitted

1 VOTE

Feature to perform Machine Learning predictive analysis and classification in MongoDB

I want to bring the machine learning compute and predictive analysis into MongoDB atlas. Instead of ETL my data out of Atlas to achieve this, I will reduce my architectural complexity by having an aggregation operator that does this on my document...

Guest over 2 years ago in Querying & Aggregations 0 Submitted

1 VOTE

Add Relaxed mode support for the $out operator

Add Relaxed mode support for the $out operator. *and include as option in the existing drivers

Guest over 2 years ago in Querying & Aggregations 0 Submitted

1 VOTE

Aggregations should allow an empty sort stage instead of returning an error

When you run an aggregation pipeline that contains an empty sort stage (like `{"$sort": {}}`) MongoDB returns the error message "$sort stage must have at least one sort key". It would be really helpful if such a stage would work and simply not app...

Guest over 2 years ago in Querying & Aggregations 0 Submitted

1 VOTE

Sorting support on Array fields.

Presently, I'm attempting to arrange(sort) the documents within my collection based on a key nested within an array object. However, sorting isn't functioning as expected in this scenario. A proper explanation with example is here what I mean. ht...

Guest over 2 years ago in Querying & Aggregations 0 Submitted

2 VOTE

support $lookup for update aggregation

We frequently denormalise either full documents or subsets to different documents in order to speed up reading, create indexes or paginate/sort on fields. Consider a user collection and a task collection, if a task can be assigned to the user, it...

Guest about 5 years ago in Querying & Aggregations 2 Submitted

1 VOTE

JSON

I'm converting a lot of data for export from MongoDB -> Postgresql I would like an aggregation function to convert an object to JSON { "$addField": { "_id": true, "json": { '$convert': { 'input': '$subdocument', 'to': 'json', # // Id...

Guest over 2 years ago in Querying & Aggregations 0 Submitted

Please enter your email address

FILTER BY CATEGORY