We are using elastic search SQL REST API.
"query": "SELECT * FROM library limit 100"
If i use limit 0,100, its not working.
And, i want to use pagination in application. is there any way to use offset in query?
Any other way to achieve pagination functionality.