CosmosDB 联接(SQL API) [英] CosmosDB Join (SQL API)

问题描述

我正在通过 SQL API 使用 CosmosDB，并且我正在尝试加入两个集合.我在文档中看到了 join 示例，但没有得到实际内容.

I'm using CosmosDB using SQL API and I'm trying to join two collections. I saw join example within a document but not getting what actually looking.

请求日志

{
"DateTimeStamp": "2018-03-16T10:56:52.1411006Z",
"RequestId": "8ce80648-66e2-4357-98a8-7a71e8b65301",
"IPAddress": "0.0.0.173"
}

响应日志

{
"DateTimeStamp": "2018-03-16T10:56:52.1411006Z",
"RequestId": "8ce80648-66e2-4357-98a8-7a71e8b65301",
"Body": "Hello"
}

是否可以同时加入两个系列?怎么样?

Is it possible to join both collections? how?

推荐答案

其实 Cosmos DB JOIN 操作仅限于单个文档的范围.您可以将父对象与同一文档下的子对象连接起来.

Actually Cosmos DB JOIN operation is limited to the scope of a single document. What possible is you can join parent object with child objects under same document.

跨文档联接不受支持，因此您必须自己实现此类查询.

Cross-document joins are NOT supported, so you would have to implement such query yourself.

这篇关于CosmosDB 联接(SQL API)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！