I'm using Logstash as a ETL tool to copy data from Elastic index to DB table. I tried to map a nested field using following insert statement in the logstash configuration;
statement => ["INSERT into assets (id, title, productid) values (?,?,?)", "id", "title", "[products][productId]"]
productId is a nested field within products object.
The insert statement I have used doesn't work as the productId column in the DB does not get populated while the other fields are added.
Appreciate if you could assist.