I wrote a logstash configuration file to sql server (a simple one, taking the table as is and index it), but i want to store each row (documents) from the table as an array in elastic. Do I need to write it at the filter section or at the output section or even at the sql statement?
Can someone show me an example how to do it?
I want the JSON will look like this:
“Values”: [ "field1value", "field2value", “field3value”....],
*each table on my db has 4 generic columns: X,Y,serialnumber and Shape
**the x,y are the center of the polygon(for kibana)
***the shape is a an array of coordinates.
****I only need to insert each table once (no new rows will be added)