When i use _id in a elasticsearch sql,
GET /_sql
{
"query": """
select * from question where _id='RzSIwnABg0jflGUtAmBx'
"""
}
i get an error.
{
"error": {
"root_cause": [
{
"type": "verification_exception",
"reason": "Found 1 problem\nline 2:32: Unknown column [_id]"
}
],
"type": "verification_exception",
"reason": "Found 1 problem\nline 2:32: Unknown column [_id]"
},
"status": 400
}
Anyone can help?Thanks.