How to generate _id field manually

[Jenni]

This is a constraint of SQL:

Is there a way to access internal _id and _type fields in ES SQL query (XPack)?

Hi @j_bennet, Indeed, this is not possible. The reason is that in SQL, an user is able to search for columns (fields) that they know about and that they actually inserted in Elasticsearch. But the _id and the _type are not fields/columns that you actually put in an index, this is more like meta information. And we bypass these fields in ES SQL by default. For _id we have a github issue created, but it's not on a concrete roadmap at the moment. Also, if I may, I'd like to comment on a stateme…