How to return document id from sql query?

Elastic Stack Elasticsearch
1

Is there a way to return the document id from the SELECT sql query? I tried to use _id, but got Unknown column [_id]

2

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

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.