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
已提问 4 年前1820 查看次数
2 回答
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
已回答 2 年前
  • Does it support it now?

  • Hi! any updates for uncorrelated subqueries?

0

Same case here, any one know how to workaround?

已回答 3 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则