es8 的 SQL 语句是否不支持分页查询?

查询语句 { "query": "SELECT * FROM session WHERE (SrcIP='222.18.11.176') OR (SrcIP='121.48.198.1') OR (SrcIP='222.18.10.139' AND DstIP='111.13.235.34') AND ltime BETWEEN '1727417891000' AND '1727421491000' LIMIT 100 OFFSET 900" } 结果 { "error": { "root_cause": [ { "type": "parsing_exception", "reason": "line 1:196: mismatched input 'OFFSET' expecting " } ], "type": "parsing_exception", "reason": "line 1:196: mismatched input 'OFFSET' expecting ", "caused_by": { "type": "input_mismatch_exception", "reason": null } }, "status": 400 }