Hope someone can help. I've looked all over Google and this forum without finding the answer.
Lets say I have three tables -
Columns - productid, productName (productId is unique)
Columns - colourId, productId, colour (colourId is unique)
Columns - sizeId, productId, colourId, size (sizeId is unique)
The relationship is 1:M:M
How do I build the configuration within Logstash so I can get the tables into Elasticsearch so the Colour & Size values are nested within the document of Product and keep their own relationships at the same time?
Thanks for any help.