[SERVER-23201] provide union operator to union two collections (or more) - MongoDB Jira

XML

Word

Printable

This is similar to SQL UNION where two selects/finds combine their results as if from one entity.

SELECT column_name(s) FROM table1

UNION

SELECT column_name(s) FROM table2;

depends on

SERVER-45712 Remove flag guard for $unionWith

duplicates

SERVER-45712 Remove flag guard for $unionWith

is duplicated by

SERVER-33788 db.createView to allow UNION of multiple collections

SERVER-25434 $lookup: allow option for FULL outer-join

is related to

SERVER-44878 Support to read and write to/from a parallel data pipeline as part of aggregation stages

Participants:: Asya Kamsky, Backlog - Query Team, Charlie Swanson, Devendra Chauhan, Saju