We will be expanding the Azure Cosmos DB grammar to support GROUP BY and DISTINCT. Thank you everyone for voting for this feature. We will update this item as soon as we have additional details to share.
Meanwhile, we recommend using the Spark connector: https://docs.microsoft.com/en-us/azure/cosmos-db/spark-connector or https://docs.microsoft.com/en-us/azure/cosmos-db/change-feed to perform aggregates like Group By.Anonymous supported this idea ·Anonymous commented
What use are aggregate functions without group by ? Please fix, love the sound of this product but this is a major roadblock to use