How can we improve Azure Cosmos DB?

← Azure Cosmos DB

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.

2,820 votes
Vote
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Johan Ohlin shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

79 comments

Attach a File
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Philip Lupercio commented  ·   ·  Flag as inappropriate

    We moved to Couchbase because of this, too. My applications just could not wait any longer and I have stakeholders I need to satisfy. They are also getting support for SQL windowing functions + GROUP BY as well as other very useful analytics functions... CTEs, UDFs, cross-document join, multi-document ACID transactions, etc...

    Perhaps will reevaluate Cosmos DB in the years to come.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I totally agree with Nate. It's been quite long since the status is just "coming soon". At least provide a reasonable ETA so that we can plan accordingly.

  • Nate commented  ·   ·  Flag as inappropriate

    I'm sorry, but throwing in spark for the sake of a standard query capability seems a bit excessive, to put it mildly. This has been going on for nearly a year now - is it possible to get an actual ETA or update on this?

    I've been a big proponent of Cosmos and have used it in a number of projects for clients, but it's getting to the point of absurdity having to say "but it can't do that" - it's like a bad Meatloaf parody. Please get some of this core stuff addressed ASAP and/or provide regular updates. A year without delivery is a little underwhelming. Still waiting on autoscale RUs that were promised, as well, btw.

  • Sagar commented  ·   ·  Flag as inappropriate

    I think we are struggling big time by choosing cosmos db to store our analytical data. It does not support group by which we need so that people can customize reports and dashboards on the fly. I hope someone responds to this as soon as possible.

  • Anonymous commented  ·   ·  Flag as inappropriate

    An status update on this would be really helpful. People need to take decisions based on this.

  • jpeav commented  ·   ·  Flag as inappropriate

    Wow, how many of us need to ask for an ETA, before you actually give one?

← Previous 1 3 4

Azure Cosmos DB: SQL API

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice