sql Pagination Query

When using SQL for queries, it is not allowed to use 'Limit 10 OFFSET 20' in MySQL; Or "Limit 20, 10; Is that so?

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!