RethinkDB REQL查询，查找数组中不同值的出现次数

Question

我在rethinkDB中有这样一个表。

[{
    "Id": [
        12,
        13
    ],
    "group": "79",
    "go_Id": []
}, {
    "Id": [
        12,
        12,
        12,
        14
        14
    ],
    "group": "91",
    "go_Id": [
        16,
        16,
        16,
        19,
        19,
        20
    ]
}, {
    "Id": [
        12,
        12,
        13,
        13,
        11
    ],
    "group": "second",
    "go_Id": [
        16,
        17,
        17,
        16,
        17,
        17
    ]
}]

我希望Id和go_Id具有单个Id的计数和它们的出现次数。例如，期望的输出是

   [{
       "Id": [
           12: 1
           13: 1
       ],
       "group": "79",
       "go_Id": []
   }, {
       "Id": [
           12: 3
           14: 2
       ],
       "group": "91",
       "go_Id": [
           16: 3,
           19: 2,
           20: 1
       ]
   }, {
       "Id": [
           12: 2,
           13: 2,
           11: 1
       ],
       "group": "second",
       "go_Id": [
           16: 2,
           17: 4,
       ]
   }]

我该怎么做呢?

我尝试根据id分组，然后计数，但似乎不起作用。比如r.table('dev').group(r.row('Id"))

Answer 1

应该这样做:

r.table('dev').merge(function(row) {
  return {Id: row('Id').group(function(x) { return x; }).count().ungroup()};
})