Is there a way to return the document id from the SELECT sql query? I tried to use _id, but got Unknown column [_id]
Hey @hongyuan1306,
At the moment this is not possible, unless you have an explicit regular field defined as ID.
But, there is an issue open for considering this as an enhancement: https://github.com/elastic/elasticsearch/issues/30266