Amazon DocumentDB `MongoServerError: Aggregation stage not supported: $lookup on multiple join conditions and uncorrelated subquery`

cfregly commented 1 year ago

MongoServerError: Aggregation stage not supported: '$lookup on multiple join conditions and uncorrelated subquery'
    at Connection.onMessage (/home/ubuntu/chat-ui/node_modules/mongodb/lib/cmap/connection.js:202:26)
    at MessageStream.<anonymous> (/home/ubuntu/chat-ui/node_modules/mongodb/lib/cmap/connection.js:61:60)
    at MessageStream.emit (node:events:513:28)
    at processIncomingData (/home/ubuntu/chat-ui/node_modules/mongodb/lib/cmap/message_stream.js:124:16)
    at MessageStream._write (/home/ubuntu/chat-ui/node_modules/mongodb/lib/cmap/message_stream.js:33:9)
    at writeOrBuffer (node:internal/streams/writable:392:12)
    at _write (node:internal/streams/writable:333:10)
    at Writable.write (node:internal/streams/writable:337:10)
    at TLSSocket.ondata (node:internal/streams/readable:766:22)
    at TLSSocket.emit (node:events:513:28) {
  ok: 0,
  code: 304,
  operationTime: new Timestamp({ t: 1685146597, i: 1 }),
  [Symbol(errorLabels)]: Set(0) {}

any thoughts on a quick fix?

sharad-fulcrum commented 1 year ago

Hey @cfregly I am running into similar issue. Curious to know if you have workaround that wouldn't make the query excessively slow

omidraha commented 5 months ago

huggingface / chat-ui

Amazon DocumentDB `MongoServerError: Aggregation stage not supported: $lookup on multiple join conditions and uncorrelated subquery` #268