Feature request : _approx_count_distinct

[AnkitPrabhu]

Hi @socketman2016, sorry for the delay. You can emit the key whose distinct value you want and then use reduce _count. While querying you can use group_level till which you want the distinct value and count the number of rows returned.
You can check this forum post which is similar to this

Views and count distinct

Hi @socketman2016, You could create a map function which emits client and user and reduce function _count. Then call the view with group_level=2 and start key as [client, null] and end key as [client, “\uffff”] and count the number of row returned. This will be the number of distinct user for that client for startkey[0]. Map: function (doc, meta) { emit([doc.client, doc.user]); } reduce: _count Query: Querying for distinct user for client “a”. stale=false&inclusive_end=true&full_set=tr…