![]() Try to export "listingsAndReviews" from sample_airbnb (or any other collection where a document object contains properties in some cases and no properties in others)Įxport of collection into a JSON file.Load the sample data set into your cluster.In both cases Compass exports all the data. In the example above by either unticking "review_scores" or all of review_scores's properties listed in dot notation. It operates on version 1.24.1.įurthermore, you can circumvent this issue by either unticking the object field in the export settings window or by unticking all the individual object properties. Or right-click anywhere on a Result tab (Collection Tab, SQL Query. Alternatively, you can right-click on any server, database, or collection in the Connection Tree and choose Export (Collections, Buckets, Views). On my private mac this issue does not occur. Once c onnected to a MongoDB database, open the Export Wizard by clicking on Export in the Global Toolbar. We tested the behavior on two devices operating on Compass version 1.26.0 accessing different clusters. Compass thereby does not comply with the mongoDB Path Collision Restrictions introduced in mongoDB 4.4 ( ). In the airbnb case it includes "review_scores" and "review_scores.review_scores_accuracy" etc. Should an object contain properties in some documents and none in others, the export function provides an export field for the object in general as well as a field for each object property. For example, the error currently pops up when trying to export the "listingsAndReviews" collection of the airbnb sample record. The reason for this is a self-inflicted path collision error (see picture 1). This error occurs when a certain object contains properties (/fields and values) in some documents and is empty in others. It runs on 64-bit versions of Mac OS X, Windows, Ubuntu 14.04+ and RHEL 7+. Load the sample data set into your cluster Use Compass 1.26.0 Try to export 'listingsAndReviews' from sampleairbnb (or any other collection where a document object contains properties in some cases and no properties in others) Expected Results. As per MongoDB documentation here MongoDB Compass works with MongoDB Server version 3.0 and higher, both Enterprise and Community editions. In both cases Compass exports all the data. The collection export function of Compass 1.26.0 is faulty. Then you install the Compass, From MongoDB Compass you can easily import and export the collection data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |