Getting internal "_id" field via jdbc

[Kenjiro]

Hello,

@dadoonet

BTW I did not check initially but where dii you see that you can't access the _id field using the SQL layer?

This is stated here, on several posts from elastic team members. One example being --> Is there a way to access internal _id and _type fields in ES SQL query (XPack)?

@dadoonet

As you can see, many options. So please clarify your exact need and architecture so we can give even better answers

I need to extract data from elasticsearch into a relational database. Since the data contains no logical unique keys (even not a composite one), I have to rely elastic _id field to ensure data consistency. But I cannot reach the field via elasticsearch JDBC driver.

Any suggestions?