joaoftrodrigues / atpdb-cleanup-and-conversion-to-relational

0 stars 0 forks source link

Open joaoftrodrigues opened 1 year ago

joaoftrodrigues commented 1 year ago

Description

Decompose set of values into single one, and then separate each item in two.

inescelorico commented 1 year ago

41 values as type int (32-bit integer) at Score field:

db.atpplayers.aggregate([{"$project":{ _id:0, "fieldType":{ "$type":"$Score"}}},{"$group":{ _id:{"fieldType":"$fieldType"},count:{$sum: 1}}}])
- { _id: { fieldType: 'string' }, count: 1308794 },
- { _id: { fieldType: 'int' }, count: 41 }