Keep relational data nested in one document


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.

check these 2 links. Related problem.

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