Hi Everyone in this Great Community,
I am working on making a central DB from 30 files of database files most of them Json Files
I have made a schema and faced this 40M JSON Document with this Structure:
{"_id":{"$oid":"5fc8d0dfa8bf583ff047b691"},
"a":"humble, texas, united states",
"t":["1-619-549-5428","1-316-871-3930","1-801-953-3210","1-409-755-0267","1-314-989-0140","1-316-683-8794"],
"e":["iluv2flie@yahoo.com","billy.mckay@gmail.com"],
"liid":"billy-mckay-64217246",
"linkedin":"https://www.linkedin.com/in/billy-mckay-64217246",
"n":"billy mckay"}
Screenshot:
I want to modify all 4 Million Documents in the JSON Database to look like this:
{"_id":{"$oid":"5fc8d0dfa8bf583ff047b691"},
"a":"humble, texas, united states",
"t":{"phone1":"1-619-549-5428","phone2":"1-316-871-3930","phone3":"1-801-953-3210","phone4":"1-409-755-0267","1-314-989-0140","1-316-683-8794"},
"e":{"email1":"iluv2flie@yahoo.com","email2":"billy.mckay@gmail.com"},
"liid":"billy-mckay-64217246",
"linkedin":"https://www.linkedin.com/in/billy-mckay-64217246",
"n":"billy mckay"}
Thank you so much