Re: importJson failed which include mongo date type file
Posted by: Krzysztof Grzadziel
Date: October 17, 2019 03:21AM

MySQL Shell importJson functionality does BSON data types conversions of Strict Mode MongoDB Extended JSON v1 [1].

Value of $date field in primer-dataset.json file isn't compliant with Strict Mode of MongoDB Extended JSON v1 [2].

[1] https://docs.mongodb.com/manual/reference/mongodb-extended-json-v1/
[2] https://docs.mongodb.com/manual/reference/mongodb-extended-json-v1/#date

primer-dataset.json date fields are like: {"date": {"$date": 1393804800000}}
but it should be like {"date": {"$date": 2014-03-03T01:00:00.000}}

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: importJson failed which include mongo date type file
304
October 17, 2019 03:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.