Elasticsearch query to return all records

by

I think lucene syntax is supported so:

http://localhost:9200/foo/_search?pretty=true&q=*:*

size defaults to 10, so you may also need &size=BIGNUMBER to get more than 10 items. (where BIGNUMBER equals a number you believe is bigger than your dataset)

BUT, elasticsearch documentation suggests for large result sets, using the scan search type.

EG:

curl -XGET 'localhost:9200/foo/_search?search_type=scan&scroll=10m&size=50' -d '
{
    "query" : {
        "match_all" : {}
    }
}'

and then keep requesting as per the documentation link above suggests.

EDIT: scan Deprecated in 2.1.0.

scan does not provide any benefits over a regular scroll request sorted by _doc. link to elastic docs (spotted by @christophe-roussy)

More Related Contents:

  1. Elastic search, multiple indexes vs one index and types for different data sets?
  2. Display dynamic image from database or remote source with p:graphicImage and StreamedContent
  3. Version of SQLite used in Android?
  4. What are the performance characteristics of sqlite with very large database files? [closed]
  5. Primary keys with Apache Spark
  6. What are database normal forms and can you give examples? [closed]
  7. Exposing database IDs – security risk?
  8. How can I put a database under git (version control)?
  9. How to use mongoimport to import csv
  10. NoSql vs Relational database
  11. How to recover a corrupt SQLite3 database?
  12. Best way to test a MS Access application?
  13. How to display table data more clearly in oracle sqlplus
  14. internationalization in JSF with ResourceBundle entries which are loaded from database
  15. Kill a postgresql session/connection
  16. What is the most efficient way to store tags in a database?
  17. How to backup sqlite database?
  18. What are the use cases of Graph-based Databases (http://neo4j.org/)? [closed]
  19. Saving images: files or blobs?
  20. Still Confused About Identifying vs. Non-Identifying Relationships
  21. How can I solve Postgresql SCRAM authentication problem?
  22. many-to-many relationship in database design
  23. What is the difference between Non-Repeatable Read and Phantom Read?
  24. Ideas on database design for capturing audit trails [closed]
  25. I need a client side browser database. What are my options [closed]
  26. How does the HyperLogLog algorithm work?
  27. Android: Where are database files stored?
  28. SQL DataType – How to store a year?
  29. Maximum number of rows in a sqlite table
  30. Any example of a necessary nullable foreign key?

Leave a Comment