$push accumulator for building arrays in MongoDB - Deep Dive

Overview - $push accumulator for building arrays

What is it?

$push is an accumulator operator in MongoDB used during aggregation to collect values into an array. It gathers all values from documents processed in a group stage and builds a single array containing them. This helps combine multiple values into one list for further analysis or output. It is simple but powerful for grouping related data together.

Why it matters

Without $push, combining multiple values from different documents into one list would require complex client-side processing or multiple queries. $push solves this by letting the database efficiently gather and organize data into arrays during aggregation. This saves time, reduces data transfer, and enables powerful data transformations inside the database itself.

Where it fits

Before learning $push, you should understand MongoDB basics, documents, and aggregation pipelines. After $push, you can explore other accumulators like $addToSet or $push with modifiers like $each and $slice for more control over arrays.

Mental Model

Core Idea

$push collects values from multiple documents into one array during aggregation grouping.

Think of it like...

Imagine a classroom where each student writes a word on a card. The teacher collects all cards from the students and puts them into one big box labeled with the group name. $push is like the teacher gathering all those cards into one box.

Aggregation Pipeline Stage: $group
┌───────────────┐
│ Group Key     │
├───────────────┤
│ Document 1    │
│ Document 2    │
│ Document 3    │
└──────┬────────┘
       │
       ▼
┌─────────────────────────────┐
│ $push accumulator collects:  │
│ [value1, value2, value3]     │
└─────────────────────────────┘

Build-Up - 7 Steps

1

Foundation

Understanding MongoDB Aggregation Basics

Concept: Learn what aggregation pipelines and stages are in MongoDB.

Aggregation pipelines process data step-by-step. Each stage transforms the data. The $group stage groups documents by a key and can use accumulators to combine data.

Result

You can group documents and prepare to combine their fields.

Understanding aggregation pipelines is essential because $push only works inside these pipelines, specifically in the $group stage.

2

Foundation

What is an Accumulator in Aggregation?

Concept: Accumulators combine multiple values into one result during grouping.

Accumulators like $sum add numbers, $avg calculates averages, and $push collects values into arrays. They summarize or collect data from grouped documents.

Result

You know that accumulators process multiple documents into one output value.

Recognizing $push as an accumulator helps you see it as a tool to gather values, not just a simple operator.

3

Intermediate

Using $push to Build Arrays

🤔Before reading on: do you think $push adds unique values only or all values including duplicates? Commit to your answer.

Concept: $push collects all values from grouped documents into an array, including duplicates.

In a $group stage, specify $push with the field to collect. For example: {$group: {_id: "$category", items: {$push: "$item"}}} This creates an array 'items' with all 'item' values from documents sharing the same category.

Result

The output groups documents by category and lists all items in an array, duplicates included.

Knowing $push includes duplicates helps you decide when to use $push versus $addToSet, which only adds unique values.

4

Intermediate

Combining $push with $each for Multiple Values

🤔Before reading on: do you think $push can add multiple values at once or only one value per document? Commit to your answer.

Concept: $push can use $each to add multiple values from an array field into the result array.

If documents have an array field, use $push with $each to flatten and add all elements: {$group: {_id: "$category", allTags: {$push: {$each: "$tags"}}}} This adds each tag from the 'tags' array of each document into 'allTags'.

Result

The output array contains all tags from all documents in the group, combined into one array.

Understanding $each lets you handle nested arrays and combine them smoothly during aggregation.

5

Intermediate

Limiting Array Size with $slice Modifier

Concept: $push supports $slice to keep only a subset of the collected array elements.

You can limit the size of the array built by $push by adding $slice: {$group: {_id: "$category", recentItems: {$push: {$each: "$items", $slice: -5}}}} This keeps only the last 5 items in the array.

Result

The output arrays contain at most 5 elements, the most recent ones.

Knowing how to limit array size prevents memory issues and keeps results manageable.

6

Advanced

Performance Considerations with Large Arrays

🤔Before reading on: do you think $push arrays grow without limit or have built-in size caps? Commit to your answer.

Concept: $push arrays can grow large and impact performance; MongoDB has limits on document size that affect this.

When $push collects many values, the resulting array can become very large. MongoDB limits document size to 16MB, so very large arrays can cause errors or slow queries. Use $slice or $limit early to control size.

Result

Awareness of limits helps avoid aggregation failures or slowdowns.

Understanding resource limits guides you to write efficient aggregations that scale.

7

Expert

Internal Handling of $push in Aggregation Engine

🤔Before reading on: do you think $push builds arrays incrementally or collects all data then builds arrays at once? Commit to your answer.

Concept: $push accumulates values incrementally as documents stream through the aggregation pipeline.

MongoDB's aggregation engine processes documents one by one in the $group stage. $push adds each value to an internal array as it processes each document, not after all documents are read. This streaming approach is memory efficient but requires careful array size management.

Result

You understand how $push works under the hood to optimize performance.

Knowing $push's incremental accumulation explains why controlling array size is critical in production.

Under the Hood

$push works inside the $group stage of the aggregation pipeline. As MongoDB processes each document, it adds the specified field's value to an internal array for the current group key. This happens incrementally, so the array grows as documents stream in. The engine manages memory and enforces document size limits to prevent overflow. Modifiers like $each and $slice adjust how values are added or trimmed during this process.

Why designed this way?

MongoDB designed $push to accumulate values incrementally to handle large datasets efficiently without waiting for all documents before building arrays. This streaming design reduces memory spikes and allows early pipeline stages to filter or limit data. Alternatives like collecting all data first would be slower and more memory-intensive. The design balances flexibility, performance, and resource constraints.

Aggregation Pipeline
┌───────────────┐
│ Input Docs    │
├───────────────┤
│ Doc1         │
│ Doc2         │
│ Doc3         │
└──────┬────────┘
       │
       ▼
┌─────────────────────────────┐
│ $group Stage                │
│ ┌─────────────────────────┐ │
│ │ Group Key: value         │ │
│ │ Internal Array: []       │ │
│ │ Process Doc1: push val1  │ │
│ │ Array: [val1]            │ │
│ │ Process Doc2: push val2  │ │
│ │ Array: [val1, val2]      │ │
│ │ Process Doc3: push val3  │ │
│ │ Array: [val1,val2,val3]  │ │
│ └─────────────────────────┘ │
└─────────────────────────────┘
       │
       ▼
┌───────────────┐
│ Output Doc    │
│ {groupKey,    │
│  array: [...] │
│ }             │
└───────────────┘

Myth Busters - 4 Common Misconceptions

Quick: Does $push automatically remove duplicate values from the array? Commit yes or no.

Common Belief: $push only adds unique values to the array, so duplicates are removed automatically.

Reality: $push adds every value it sees, including duplicates. It does not filter or remove duplicates.

Why it matters: Assuming $push removes duplicates can cause unexpected repeated values in results, leading to incorrect data analysis or display.

Quick: Can $push be used outside the $group stage in aggregation? Commit yes or no.

Common Belief: $push can be used anywhere in the aggregation pipeline to build arrays.

Reality: $push is an accumulator and only works inside $group or $facet stages where grouping happens.

Why it matters: Trying to use $push outside $group causes errors or no effect, confusing beginners about pipeline capabilities.

Quick: Does $push automatically limit the size of the array it builds? Commit yes or no.

Common Belief: $push arrays have a built-in size limit and will stop growing automatically.

Reality: $push arrays grow without limit until hitting MongoDB's document size limit, unless you explicitly use $slice or other modifiers.

Why it matters: Ignoring array size can cause aggregation failures or performance issues in production.

Quick: Does $push add multiple values from an array field automatically? Commit yes or no.

Common Belief: $push automatically flattens arrays and adds all their elements individually.

Reality: $push adds the entire array as one element unless combined with $each to add elements individually.

Why it matters: Misunderstanding this leads to nested arrays in results when flat arrays were expected.

Expert Zone

1

$push arrays are built incrementally, so the order of documents affects the array order, which can be important for time-series or ordered data.

2

Using $push with $each and $slice together allows efficient pagination or limiting of array size without extra pipeline stages.

3

$push can be combined with $sort inside $group using $push with $each and $sort modifiers (MongoDB 5.2+) to build sorted arrays directly.

When NOT to use

Avoid $push when you need only unique values; use $addToSet instead. For very large arrays, consider restructuring data or using $limit early. If you need sorted arrays, use $push with $sort or sort after aggregation.

Production Patterns

In production, $push is used to gather related items like comments per post, tags per product, or events per user. It is often combined with $match and $sort before $group to control data volume and order. Developers use $push with $each and $slice to implement features like recent activity feeds or limited history lists.

Connections

Set Theory

$push collects all elements including duplicates, while set theory focuses on unique elements.

Understanding the difference between multisets (like $push arrays) and sets (like $addToSet) clarifies when to use each accumulator.

Streaming Data Processing

$push accumulates values incrementally as data streams through the pipeline.

Knowing streaming concepts helps grasp why $push builds arrays on the fly and why controlling size matters.

Event Collection in Analytics

$push is like collecting user events into arrays for analysis.

Seeing $push as event aggregation helps understand its role in building timelines or histories in analytics systems.

Common Pitfalls

#1 Creating arrays with duplicate values when unique values are needed.

Wrong approach:

{$group: {_id: "$category", items: {$push: "$item"}}}

Correct approach:

{$group: {_id: "$category", items: {$addToSet: "$item"}}}

Root cause:

Confusing $push with $addToSet and not realizing $push includes duplicates.

#2 Using $push outside of $group stage causing errors.

Wrong approach:

{$project: {allItems: {$push: "$item"}}}

Correct approach:

{$group: {_id: "$category", allItems: {$push: "$item"}}}

Root cause:

Misunderstanding that $push is an accumulator only valid in grouping contexts.

#3 Building very large arrays without limits causing memory or size errors.

Wrong approach:

{$group: {_id: "$category", allItems: {$push: "$item"}}}

Correct approach:

{$group: {_id: "$category", recentItems: {$push: {$each: "$item", $slice: -100}}}}

Root cause:

Not controlling array size leads to exceeding MongoDB document size limits.

Key Takeaways

$push is a MongoDB accumulator that collects values into arrays during aggregation grouping.

It includes all values, duplicates included, unlike $addToSet which keeps unique values only.

$push works incrementally as documents stream through the pipeline, so array order matches document order.

Modifiers like $each and $slice extend $push to handle arrays and limit size efficiently.

Understanding $push's behavior and limits helps write efficient, correct aggregation queries for real-world data.

Practice

1. What does the $push accumulator do in a MongoDB aggregation pipeline?

easy

A. It removes duplicate values from an array.

B. It adds values to an array for each group in the aggregation.

C. It sorts the documents in the aggregation result.

D. It counts the number of documents in each group.

Solution

1. Step 1: Understand the purpose of $push

   The $push accumulator collects values into an array for each group during aggregation.

2. Step 2: Compare with other accumulators

   Unlike $addToSet which removes duplicates, $push simply appends values, allowing duplicates.

3. Final Answer:

   It adds values to an array for each group in the aggregation. -> Option B

4. Quick Check:

   $push = add values to array [OK]

Hint: Remember: $push always appends values to arrays [OK]

Common Mistakes:

• Confusing $push with $addToSet which removes duplicates
• Thinking $push sorts the array automatically
• Assuming $push counts documents instead of collecting values

2. Which of the following is the correct syntax to use $push in a MongoDB aggregation $group stage?

easy

A. { $group: { _id: "$category", items: { $push: { "$item" } } } }

B. { $group: { _id: "$category", items: { $push: ["$item"] } } }

C. { $group: { _id: "$category", items: { $push: "$item" } } }

D. { $group: { _id: "$category", items: { push: "$item" } } }

Solution

1. Step 1: Review correct $push syntax

   The $push operator requires a field name with a value to push, like $push: "$item".

2. Step 2: Identify syntax errors in options

   { $group: { _id: "$category", items: { $push: ["$item"] } } } incorrectly uses an array around "$item". { $group: { _id: "$category", items: { $push: { "$item" } } } } uses braces instead of quotes. { $group: { _id: "$category", items: { push: "$item" } } } misses the $ sign before push.

3. Final Answer:

   { $group: { _id: "$category", items: { $push: "$item" } } } -> Option C

4. Quick Check:

   Correct $push syntax = { $group: { _id: "$category", items: { $push: "$item" } } } [OK]

Hint: Use $push: "fieldName" inside $group stage [OK]

Common Mistakes:

• Forgetting the $ before push
• Using arrays or objects incorrectly inside $push
• Misplacing quotes around field names

3. Given the collection orders with documents:

{ "customer": "Alice", "product": "Pen" }

{ "customer": "Alice", "product": "Notebook" }

{ "customer": "Bob", "product": "Pen" }

What will be the result of this aggregation?

{ $group: { _id: "$customer", products: { $push: "$product" } } }

medium

A. [{ "_id": "Alice", "products": ["Pen", "Notebook"] }, { "_id": "Bob", "products": ["Pen"] }]

B. [{ "_id": "Alice", "products": "Pen" }, { "_id": "Bob", "products": "Pen" }]

C. [{ "_id": "Alice", "products": ["Notebook"] }, { "_id": "Bob", "products": ["Pen"] }]

D. [{ "_id": "Alice", "products": [] }, { "_id": "Bob", "products": [] }]

Solution

1. Step 1: Group documents by customer

   The aggregation groups documents by the "customer" field, so Alice and Bob form separate groups.

2. Step 2: Use $push to collect products

   For each group, $push collects all "product" values into an array. Alice has "Pen" and "Notebook", Bob has "Pen".

3. Final Answer:

   [{ "_id": "Alice", "products": ["Pen", "Notebook"] }, { "_id": "Bob", "products": ["Pen"] }] -> Option A

4. Quick Check:

   Group by customer + $push products = [{ "_id": "Alice", "products": ["Pen", "Notebook"] }, { "_id": "Bob", "products": ["Pen"] }] [OK]

Hint: Group by field, $push collects all matching values in array [OK]

Common Mistakes:

• Expecting $push to return single value instead of array
• Confusing $push with $first or $last accumulator
• Ignoring grouping effect on output structure

4. You wrote this aggregation but it throws an error:

{ $group: { _id: "$category", items: { $push: "$item" } } }

What is the likely cause of the error?

medium

A. The field names "category" or "item" do not exist in the documents.

B. You forgot to include the $match stage before $group.

C. The $push operator cannot be used inside $group.

D. The _id field cannot be a string.

Solution

1. Step 1: Check field existence in documents

   If the fields "category" or "item" do not exist in the documents, $push will fail because it tries to access missing fields.

2. Step 2: Validate other options

   $push is valid inside $group, $match is optional, and _id can be a string. So these are not causes of error.

3. Final Answer:

   The field names "category" or "item" do not exist in the documents. -> Option A

4. Quick Check:

   Missing fields cause $push error [OK]

Hint: Verify fields exist before using $push on them [OK]

Common Mistakes:

• Assuming $push requires $match stage
• Thinking _id cannot be string
• Believing $push is invalid inside $group

5. You want to group sales by store and collect all product names sold, but only unique products without duplicates. Which aggregation pipeline correctly uses $push and another operator to achieve this?

hard

A. { $group: { _id: "$store", products: { $push: "$product" } } }

B. { $group: { _id: "$store", products: { $push: { $each: "$product" } } } }

C. { $group: { _id: "$store", products: { $push: { $addToSet: "$product" } } } }

D. { $group: { _id: "$store", products: { $addToSet: "$product" } } }

Solution

1. Step 1: Understand $push vs $addToSet

   $push collects all values including duplicates. $addToSet collects unique values only.

2. Step 2: Identify correct usage for unique array

   To get unique products per store, use $addToSet: "$product" inside $group.

3. Step 3: Analyze other options

   { $group: { _id: "$store", products: { $push: "$product" } } } uses $push (duplicates allowed). { $group: { _id: "$store", products: { $push: { $addToSet: "$product" } } } } nests $addToSet inside $push which is invalid. { $group: { _id: "$store", products: { $push: { $each: "$product" } } } } misuses $each inside $push.

4. Final Answer:

   { $group: { _id: "$store", products: { $addToSet: "$product" } } } -> Option D

5. Quick Check:

   Unique array needs $addToSet, not $push [OK]

Hint: Use $addToSet for unique arrays, $push allows duplicates [OK]

Common Mistakes:

• Using $push when unique values are needed
• Nesting $addToSet inside $push incorrectly
• Misusing $each inside $push accumulator