I have a couple of valid JSON documents and I try to import them in mongodb.
{ "Books":
[{ "ISBN":"ISBN-0-13-713526-2",
"Price":85,
"Edition":3,
"Title":"A First Course in Database Systems",
"Authors":[ {"First_Name":"Jeffrey", "Last_Name":"Ullman"},
{"First_Name":"Jennifer", "Last_Name":"Widom"} ] }
,
{ "ISBN":"ISBN-0-13-815504-6",
"Price":100,
"Remark":"Buy this book bundled with 'A First Course' - a great deal!",
"Title":"Database Systems:The Complete Book",
"Authors":[ {"First_Name":"Hector", "Last_Name":"Garcia-Molina"},
{"First_Name":"Jeffrey", "Last_Name":"Ullman"},
{"First_Name":"Jennifer", "Last_Name":"Widom"} ] }],
"Magazines":
[{ "Title":"National Geographic",
"Month":"January",
"Year":2009 }
,
{ "Title":"Newsweek",
"Month":"February",
"Year":2009 },
{"Title": "Newsweek"}]
}
I got the following error:
Sun Mar 24 15:23:27 exception:BSON representation of supplied JSON is too large: Failure parsing JSON string near: "Month":"J Sun Mar 24
15:23:27 exception:BSON representation of supplied JSON is too large: Failure parsing JSON string near: "Year":200 Sun Mar 24 15:28:23
ERROR: encountered 28 errors
Could someone say what's wrong?
The following command from terminal worked good for me:
mongoimport -d my_db -c my_collection < my_json_file.json --batchSize 1
Some version needs to change the --batchSize
50 instead of 1 like below:
mongoimport -d my_db -c my_collection < my_json_file.json --batchSize 50
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With