Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How do you export a large result set? #41

Open
xermus opened this issue Nov 7, 2017 · 2 comments
Open

How do you export a large result set? #41

xermus opened this issue Nov 7, 2017 · 2 comments
Labels

Comments

@xermus
Copy link

xermus commented Nov 7, 2017

The dataformat is perfectly running fine for me.

The problem is only that I need to export the whole index (which contains hundreds of thousands of documents). I then get:

Result window is too large, from + size must be less than or equal to: [10000] but was [1000000]

Can you provide me a specific example on how I can export all documents of an index to a given file (json or csv) on the Linux command line. Thank you.

@marevol
Copy link
Contributor

marevol commented Nov 12, 2017

"file" request parameter stores an exported file in elasticsearch server without storing data into a response.
ex. localhost:9200/{index}/_data?format=csv&file=/tmp/test.csv...

@sewalita
Copy link

sewalita commented Feb 20, 2018

I am looking to export all documents from the index. Using plugin v5.6.2 with ES 5.6.4, I get the following error when using the "file" parameter

"error":{"root_cause":[{"type":"illegal_argument_exception","reason":"request [/{index}/{type}/_data] contains unrecognized parameter: [file]"}]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants