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!