[SERVER-2033] Add skip and limit options for mongoexport Created: 29/Oct/10  Updated: 12/Jul/16  Resolved: 09/Dec/13

Status: Closed
Project: Core Server
Component/s: Tools
Affects Version/s: 1.6.4, 1.7.0, 1.7.1
Fix Version/s: 2.5.1

Type: New Feature Priority: Major - P3
Reporter: tommy chheng Assignee: Matt Kangas
Resolution: Done Votes: 7
Labels: pull-request
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

all


Issue Links:
Related
related to SERVER-12054 Add --sort as option for mongoexport Closed
related to DOCS-2141 Document the skip and limit options f... Closed
Backwards Compatibility: Fully Compatible
Participants:

 Description   

There should be skip and limit options in the mongoexport utility.

I have a practical use case of "show me the top 10 ranked documents in this collection" and sending the output as a CSV for excel users. The collection is millions of documents so i need limit and skip options.

This person needed as well
http://groups.google.com/group/mongodb-user/browse_thread/thread/89dbf90b0a5d9a39



 Comments   
Comment by Matt Kangas [ 08/Jul/13 ]

Pull request merged in 37697bdb58f91be434416c3b73b66ced4cb0efa0

Comment by auto [ 08/Jul/13 ]

Author:

{u'username': u'RexMorgan', u'name': u'Rex Morgan', u'email': u'rex.morgan@gmail.com'}

Message: SERVER-2033: Adding support for skip and limits withing the mongoexport tool.

Signed-off-by: Matt Kangas <matt.kangas@10gen.com>
Branch: master
https://github.com/mongodb/mongo/commit/37697bdb58f91be434416c3b73b66ced4cb0efa0

Comment by Rex Morgan [ 19/Mar/13 ]

This actually affects all versions, ticket should be updated to reflect that. I've fixed this in Pull Request #307.

Comment by John J Bungert [ 17/Mar/13 ]

Agreed, this would be a great feature to have for doing data testing.

Comment by Eliot Horowitz (Inactive) [ 14/Jul/11 ]

@mike not sure. its in "2011 - phase 1" which basically mean its in an early non schedule bucket

Comment by mike jacobi [ 13/Jul/11 ]

Will this functionality be in 2.1?

Comment by Eliot Horowitz (Inactive) [ 08/Nov/10 ]

Just a matter of adding --skip and --limit to command line args for export.cpp and then applying conditionally on the find.

Comment by tommy chheng [ 08/Nov/10 ]

Can you give a summary of what needs to be changed in the code for skip and limit options to work properly?

I'm not sure I can wait until 1.9 for this option..

Maybe I or someone can submit a patch if it's not too difficult.

Generated at Thu Feb 08 02:58:46 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.