Skip to content

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

@mengpeiyao

Description

@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
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions