Bulk update/upsert in MongoDB?

Question

Is it possible to do bulk update/upsert (not insert) in MongoDB?

If yes, please point me to any docs related to this?

Thanks

This is not possible yet: see https://jira.mongodb.org/browse/SERVER-4004 — Gianfranco P., Aug 29 '13 at 13:54

score 4 · Accepted Answer · answered Dec 14 '10 at 21:46

You can use the command line program mongoimport it should be in your MongoDB bin dir ...

There are two options you'll want to look into to use upsert ...

--upsert insert or update objects that already exist
--upsertFields arg comma-separated fields for the query part of the upsert. You should make sure this is indexed

More info here: http://www.mongodb.org/display/DOCS/Import+Export+Tools

Or just do ...

$ mongoimport --help

Note: currently --upsert isn't documented in the online docs (they need to be updated) ... but you will see it from the command line --help. — Justin Jenkins, Dec 14 '10 at 22:08

score 3 · Answer 2 · edited Jul 03 '15 at 05:39

3

mongo can execute .js file. you can push all you update commands in a js file.

t.js

db.record.update({md5:"a35f10a8339ab678612d1f86be08b81a"},{$set:{algres:[]}},false,true);
db.record.update({md5:"a35f10a8339ab678612d1f86be08b81b"},{$set:{algres:[]}},false,true);

then, mongo 127.0.0.1/test t.js

edited Jul 03 '15 at 05:39

Yurets

3,999
17
54
74

answered Jul 03 '15 at 04:36

unique

31
1

score 1 · Answer 3 · answered Dec 08 '14 at 18:01

Bulk updates can also be done in batches as found in the documentation:

MongoDB Bulk Methods

I use these to import CSV files that I need to massage a bit before importing the data. Its kinda slow when dealing with updates, but it did my 50K document updates in about 83 seconds, which is far slower than mongoimport command.

Bulk update/upsert in MongoDB?

3 Answers3

Linked