OFFSET query _sql is not recognizing

Elastic Stack Elasticsearch
1

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

2

Hi @SergioFF

I believe OFFSET not supported. Read this post.

3

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