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
preguntada hace 4 años1820 visualizaciones
2 Respuestas
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
respondido hace 2 años
  • Does it support it now?

  • Hi! any updates for uncorrelated subqueries?

0

Same case here, any one know how to workaround?

respondido hace 3 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas