Insert multiple jdbc rows into the same ES document under nested field

Elastic Stack Logstash
1

Hi,

I would like to insert in the same elasticsearch document, all jdbc rows with the same ID into a nested field called "logs".
Can someone explain me how to convert jdbc input rows of logs into the following JSON structure :

{ "id";"4dca1978-a591-4a6e-a431-1e9b0ee7a2e1", "logs":[{ "jdbcColumn1":"value1", "jdbcColumn2":"value2", "jdbcColumn3":"value3" },{ "jdbcColumn1":"value1", "jdbcColumn2":"value2", "jdbcColumn3":"value3" }] }

Thank you!

2

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