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…

OFFSET query _sql is not recognizing

RabBit_BR (andre.coelho) February 1, 2023, 7:21pm 2

I believe OFFSET not supported. Read this post.

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.