RethinkDB: COUNT Example

In RethinkDB, you can easily count the results, by adding a count predicate:

r.db('test')
 .table('users')
 .count()

If you want to reduce the results first, you can add a filter first:

r.db('test')
 .table('users')
 .filter( (x) => x('last_name').match('test ') )
 .count()

If you want to do a GROUP BY, you can do it with “GROUP”:

r.db('test')
 .table('users')
 .filter( (x) => x('user_name').match('test ') )
 .group('first_name')
 .count()
 .ungroup()
 .map(
   { 
    first_name: r.row('group'),
    val: r.row('reduction') 
  })
 .orderBy('val')

This is an example of what you’ll get: