mongodbimport Failure - FailedToParse: Expecting '{': offset:0

json mongodb arrays casbah mongoimport
Kevin Meredith picture Kevin Meredith · Sep 4, 2013 · Viewed 10.4k times · Source

I tried to import a 7.4 MB JSON file via ...

mongoimport -d mongoimport -c test --file jsonTest.json

But I saw this issue.

Wed Sep 04 13:08:52.378 exception:BSON representation of supplied JSON is too large: code FailedToParse: FailedToParse: Expecting '{': offset:0

This Stackoverflow post presented a similar issue with respect to the date occurring before Jan 1, 1970, but that doesn't seem to apply given my FailedToParse: Expecting '{': offset:0 error.

Answer

Sunny Sharma picture Sunny Sharma · Jan 8, 2014

seems I'm much late but with the correct answer:

add --jsonArray in your statement and it will work. It should read like:

mongoimport -d mongoimport -c test --file jsonTest.json --jsonArray

Cheers!!

Related questions

MongoDB rename database field within array

I need to rename indentifier in this: { "general" : { "files" : { "file" : [ { "version" : { "software_program" : "MonkeyPlus", "indentifier" : "6.0.0" } } ] } } } I've tried db.nrel.component.update( {}, { $rename: { "general.files.file.$.version.indentifier" : "general.files.file.$.version.identifier" } }, false, true ) but it returns: $rename source may …

Read More
Querying inside Postgres JSON arrays

How would you go about searching for an element inside an array stored in a json column? (Update: Also see the 9.4 updated answer for jsonb columns.) If I have a JSON document like this, stored in a json column named …

Read More
Date query with ISODate in mongodb doesn't seem to work

I don't seem to be able to get even the most basic date query to work in MongoDB. With a document that looks something like this: { "_id" : "foobar/201310", "ap" : "foobar", "dt" : ISODate("2013-10-01T00:00:00.000Z"), "tl" : 375439 } And a query …

Read More