How to paging with elasticsearch sql

[jimmy0]

The document offers "limit", but without "offset".

SELECT | Elasticsearch Guide [7.13] | Elastic

I'm using elasticsearch 7.10.1.

[dadoonet (David Pilato)]

Yes that's true. And even in 8.14 which you should definitely upgrade to: SELECT | Elasticsearch Guide [8.14] | Elastic

I know that something along those lines will be implemented in ES|QL.

ESQL: Support pagination

But I don't know if this will happen in the SQL feature.

@jimmy0

I'm using elasticsearch 7.10.1.

Please upgrade to at least 7.17.23.
Your version is missing a lot of patches including security patches.

[jimmy0]

Thanks.