Hello,
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:
“Table_name”:””,
“Values”: [ "field1value", "field2value", “field3value”....],
“X_coordinates”:””,
“Y_coordinates”:””,
“MySerialNumber”:”__”
“Shape”:”_________”
*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)
Thanks ahead!