How to export sorted data using mongoexport?

Question

I have a collection in mongo which has name and count fields.

{name:'myName',count:5}

Is it possible to sort data by count and export as json using mongoexport?

score 40 · Answer 1 · answered Apr 09 '14 at 03:33

40

Starting with MongoDB 2.6, you can pass --sort to mongoexport directly:

mongoexport --db mydatabase -c people --fields name,age --sort "{name: 1, age: 1}"

answered Apr 09 '14 at 03:33

Dan Dascalescu

score 18 · Accepted Answer · answered Jun 07 '12 at 17:50

18

Actually you can, but you have to use special params. Here's a sample (redirecting to file):

$ mongoexport  -q '{ $query: {count: {$gt:0}}, $orderby: {count: -1} }' -d database -c collection > data_dump.json

The $query part is not strictly necessary, but I included it because of this bug on GitHub (fixed now, but only just).

answered Jun 07 '12 at 17:50

rowanu

@rowanu: Hey, is this possible for group by queries? – Shashank Nov 18 '13 at 09:03
1

The solution by @rowanu doesn't works for me, but this one does: `--query '{ $query: {}, $orderby: {count: -1} }' --forceTableScan` – hennadiy.verkh Jan 24 '14 at 15:19
Yeah, my solution is nearly two years old, and was done on MongoDB version 2.0 (current stable version is 2.4, with 2.6 coming out soon) so that's not surprising. – rowanu Jan 25 '14 at 01:24
Not sure if that bug was fixed - see [this issue I filed](https://jira.mongodb.org/browse/SERVER-12665). – Dan Dascalescu Feb 10 '14 at 07:48
orderBy was deprecated. see here: https://stackoverflow.com/a/48051096/5986661 and https://docs.mongodb.com/manual/reference/operator/meta/orderby/ – Omkar Neogi Jun 07 '19 at 15:57

score -9 · Answer 3 · answered Jan 25 '12 at 20:39

-9

You can't pass in an argument to sort your documents by a specific key when using mongoexport.

The way to do this would be to write your own script.

Hope this helps.

answered Jan 25 '12 at 20:39

Barrie

3

[Yes you can](http://stackoverflow.com/a/22952270/1269037); please delete this answer. – Dan Dascalescu Apr 09 '14 at 03:33

3 Answers3