OFFSET query _sql is not recognizing

Hello, I have version 8.5.2 of Elasticsearch and I am trying to use the OFFSET clause within a query, but it is not recognizing it, can this clause be used in the version we have? The query I am sending is as follows:

GET /_sql?format=json
    "query":  """ SELECT * FROM "index" LIMIT 10 OFFSET 5 """

Can you help me? "And what options do I have if I want to paginate backwards?
Thank you very much

Hi @SergioFF

I believe OFFSET not supported. Read this post.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.