CosmosDB + group by

Question

I need to use "GROUP BY" clause on Azure Data Explorer but I think it is unsupported.

Someone have any idea to solve or avoid group by?

Best regards,

Answer 1

Finally, 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.

<group_by_clause> ::= GROUP BY <scalar_expression_list>

<scalar_expression_list> ::=
          <scalar_expression>
        | <scalar_expression_list>, <scalar_expression>