Aggregation stage not supported:lookup on multiple join conditions

1

I got the error from documentdb
Aggregation stage not supported: '$lookup on multiple join conditions and uncorrelated subquery
how to fix this do you have any solution for solving this problem?

i have 3 document to join this is lookup command

{
  from: "subscribe",
  let: {
    program_id: "$program_id"
  },
  pipeline: [
    {
      $match: {
        $expr: {
          $and: [
            {
              $eq: [
                "$program_id",
                "$$program_id"
              ]
            }
          ]
        }
      }
    },
    { "$lookup": {
        "from": "user_token",
        "let": { "user_id": "$user_id" },
        "pipeline": [
          { 
            "$match": { 
              "$expr": { 
                "$eq": [ "$user_id", "$$user_id" ] 
              }
            }
          }
        ],
        "as": "tokens"
      }
    }
    // { "$wind": "$token" }
  ],
  as: "subscribers"
}

Edited by: BECIDEV on Apr 17, 2020 1:02 AM

Edited by: BECIDEV on Apr 17, 2020 1:03 AM

BECIDEV
gefragt vor 4 Jahren1820 Aufrufe
2 Antworten
0

There's no workaround for now, the $let and $expr operators are not supported and are needed in order to achieve this extension to $lookup. As we are working backwards from customer needs, these operators may be supported in the future versions of the service.

AWS
Mihai A
beantwortet vor 2 Jahren
  • Does it support it now?

  • Hi! any updates for uncorrelated subqueries?

0

Same case here, any one know how to workaround?

beantwortet vor 3 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen