sql Pagination Query

Hi @mengpeiyao,

Welcome! I assume you are using the Elasticsearch SQL capabilities? I see from this open issue and forum post that OFFSET is not supported.

Since it looks like you're trying to do pagination I would recommend following this approach where you pass back the cursor ID from the initial request.

Hope that helps!