cosmos db的分组依据的替代方法 [英] Alternative to group by for cosmos db

问题描述

鉴于cosmos db不支持group by，那么实现类似功能的一个很好的替代方法是

Given that cosmos db does not support group by, what is a good alternative to achieve similar functionality:

Select sum(*) , groupterm from tble group by groupterm

我可以在cosmos存储过程中有效地实现这一点吗?

Can I efficiently achieve this in a cosmos stored procedure?

推荐答案

Group by.您将需要SDK版本3.3或更高版本

Group by is now supported in Cosmos db SQL API. You will be needing SDK version 3.3 or higher

Azure Cosmos DB当前在.NET SDK 3.3或更高版本中支持GROUP BY. 目前不支持其他语言的SDK和Azure门户 可用，但已计划.

Azure Cosmos DB currently supports GROUP BY in .NET SDK 3.3 or later. Support for other language SDK's and the Azure Portal is not currently available but is planned.

https://docs.microsoft. com/en-gb/azure/cosmos-db/sql-query-group-by

这篇关于cosmos db的分组依据的替代方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！