Scroll

##Elasticsearch-sql scroll In elasticsearch-sql you can use the scan & scroll feature to retrieve large numbers of documents from Elasticsearch efficiently. Read about Scan and scroll on elasticsearch official guide

How to use?

If you want to use scroll on your queries simply add this hint
SELECT /*! USE_SCROLL*/ firstname , balance FROM accounts
This will cause a scroll with default values 10k,10k to start
You can specify the values like this:
SELECT /*! USE_SCROLL(100,30000)*/ firstname , balance FROM accounts

The first value is number of documents per shard in each scroll
The second value is the how long keep the search context open (in milliseconds)

Need to know

• The combination of limit and use_scroll hint is not supported
• On scan & scroll the first result only returns a scrollId and the total number of hits matching the query.

###Web ui support Next button will appear when using with scroll , it will disappear after no more results
example: