dbdao吧 关注:1,183贴子:4,074
  • 6回复贴,共1

mongodb 计算数组去重后的总数量

只看楼主收藏回复

mongodb 计算数组去重后的总数量
{ "date" : NumberLong(20151028), "DeviceId" : [ "osfojso", "osfojsoijfiodjfo", "aabbcc" ] }
{ "date" : NumberLong(20151027), "DeviceId" : [ "aabbcc", "a" ] }
应该是4
aabbcc是重复的


1楼2015-10-29 12:06回复
    db.dd1.insert({ "date" : NumberLong(20151028), "DeviceId" : [ "osfojso", "osfojsoijfiodjfo", "aabbcc" ] });
    db.dd1.insert({ "date" : NumberLong(20151027), "DeviceId" : [ "aabbcc", "a" ] });
    > db.dd1.distinct('DeviceId');
    [ "aabbcc", "osfojso", "osfojsoijfiodjfo", "a" ]
    >
    > db.dd1.distinct('DeviceId').length;
    4


    2楼2015-10-29 12:22
    收起回复