How to do order in grouping(aggregation) in Couchbase?

[Prakash]

I have SQL query like this:

select count(id) as ct, city from table group by city order by ct desc

How can I perform this query in Couchbase? I have map function like This:

function (doc, meta) {
  if(doc.city!==null) {
  emit(doc.city,1)
    }
}

and reduce:

_count

my query url is like this: _view/q7?group_level=1&descending=true but it it sort only for key not for value.

No one had answer this here

http://stackoverflow.com/questions/23410708/how-to-do-order-in-groupingaggregation-in-couchbase

[Aliaksey Kandratsenka]

I believe it's impossible with couchdb-style views. Here's why.

What you need appears to require two sorting passes. One to group by city and get counts and another to sort by counts. And couchdb-style views only do one sorting (as part of placing view results into btree).

If only we could have views from views, then you could describe such dual-pass "topology" easily.

[Gerald]

Try N1QL:

http://www.couchbase.com/communities/n1ql