Is it possible to using _id in elasticsearch sql

Hi @jimmy0

It seems to me that it is not possible to use _id because it is not a column.

Look this answer: Is there a way to access internal _id and _type fields in ES SQL query (XPack)? - #2 by Andrei_Stefan