es8 的sql语句不支持分页查询吗

[mengpeiyao]

查询语句
{
"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
}