Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-19095

$lookup

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major - P3
    • Resolution: Done
    • None
    • 3.2.0-rc2
    • Aggregation Framework
    • None
    • Fully Compatible
    • Quint Iteration 7, QuInt 8 08/28/15, Quint 9 09/18/15, QuInt A (10/12/15)

    Description

      Summary

      Add a $lookUp operator to the aggregation pipeline to pull data from one collection into a pipeline executed on a different collection.

      Goals

      • Aggregation stage to do left outer join
      • Works across any shard/collection boundary
        • left-hand side sharded, right-hand side unsharded

      Non-Goals

      • Enforced collocation of “related” chunks.
      • More parallelization for agg
      • Small collections that co-exist on all shards (aka, “enum” collections)

      Examples

      Forthcoming

      Attachments

        Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-12685 Expand $unwind behavior to include empty documents optionally

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. SERVER-745 Embedded Document Expansion (Pseudo-JOINs)

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-5048 $project to have ability to get data from referenced collections (SQL-like "join")

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-11682 Aggregate on multiple collections

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-11865 A $findOne operator for $let,$map in $project phase

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-19270 Allow adding additional source collection to aggregation pipeline

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-432 server side expansion of DBRefs

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-970 MapReduce:add ability to process many collections at once

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-19476 Referenced Values

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-1632 improve find with using DBRef to support joins

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-21621 Piped query

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          Task - A task that needs to be done. DRIVERS-234 Aggregation Builder Support for 3.2

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-20504 Name aggregation operator for lookup: $lookup

          • Major - P3 - Major loss of function.
          • Closed
          related to

          New Feature - A new feature of the product, which has yet to be developed. CSHARP-1374 $lookup

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. JAVA-1936 Aggregation builder support for $lookup stage

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              Votes:
              9 Vote for this issue
              Watchers:
              40 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: