Hello! I have a question that I cannot find the answer to in the documentation. Can I get the _id of the document in the request like “SELECT * FROM index WHERE …”. As I understand it, in this case, I receive only the information that is in the source of document? Or not and i get _id also?
Currently only data in the source is selectable. But we do have workaround here to support get the metadata from SQL queries. Please check out and track the progress here: Support Elasticsearch meta fields · Issue #1038 · opendistro-for-elasticsearch/sql · GitHub