Add Group By support for Aggregate Functions
We're really happy about the new aggregate functions that recently were announced. But without Group By support they fall short and will leave many disappointed. Please add Group By support as well.
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.
Is there any update on this?
ram kumar commented
GroupBy is available in preview now as mentioned here:https://azure.microsoft.com/en-in/blog/azure-cosmosdb-extends-support-for-mongodb-aggregation-pipeline-unique-indexes-and-more/.
So when this is going to be live.
Ajit Sutreja commented
Is there an example/documentation of using Spark connector with C#/.NET SDK? According to this, https://docs.microsoft.com/en-us/azure/cosmos-db/spark-connector documentation you have to use JAVA or Python SDK.
Wow! it is almost 8 months since the request and there are 1327 votes for it, but we still don't have the future. I am really disappointed. :(
Hi, we are considering using MongoDB in CosmosDB, but reading the comments I guess MongoDB is not fully supported (at least, the aggregation framework). My question is, is there any place (web, forum..) where I can read if anything else is missing to analyse pro & const of using MongoDB vs DocumentDB in CosmosDB. Anyway, anyone here in this forum can shed some light on this? Thanks!
Nenad Marjanovic commented
We started using CosmosDB, we left for other solution, we tested again and we tried working with Azure support, then we moved to other platform again. A lot of vars from our application didn't work. As CosmosDB don't have all functions from native MongoDB in the end we have lost hope ... I don't know how we use this in production when we spend time being MS CosmosDB quality service. I can only say it's shame.
Rodd Harris commented
Was giving serious consideration to using this on a new project we're launching into -- however, had to drop it as serious once I realized there is no true aggregation (no group by). Can't be a serious solution without group by.
Andrew Choi commented
we definitely need this.
Is there a work around for this in the meantime? In SQL we could create a view?
Peter Molloy commented
Agree much better potential for data pipeline and analytical efficiency if more transformation libraries are provided at the language level. Top issue facing Cosmos today.
No GroupBy, No CosmosDB. Without a GroupBy feature the CosmosDB is not useful.
Critical fail for us as well :(
Critical fail. Aggregates without Group By is pretty much useless, leaving us to go through data RBAR. This needs to be fixed or else don't say you have aggregates.
Joel Varty commented
This would make adoption to Cosmos DB much easier!
What use are aggregate functions without group by ? Please fix, love the sound of this product but this is a major roadblock to use
Critical. Right now it's a show stopper.
JLo Gonzalez commented
Was disappointed when only the bare minimum to "complete" the ask for aggregate functions was added. Aggregate functions without Group By support are pretty much useless. I also hope we don't have to wait 2 years for this like we did for "Aggregate" functions
Joseph Truong commented
Would like to this implemented. Currently have to sort the result set in cosmosdb and then i have to perform some aggregation using linq (linq supports group by)
Jesus Torres commented
Very interested in this being implemented as well. Please and thanks
Jon Thomas commented
really... without this, aggregates fulfils marketing only.