Keep relational data nested in one document


#1

Hi,

Hope someone can help. I've looked all over Google and this forum without finding the answer.

Lets say I have three tables -

PRODUCT
Columns - productid, productName (productId is unique)

COLOUR
Columns - colourId, productId, colour (colourId is unique)

SIZE
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.


#2

check these 2 links. Related problem.



(system) #3

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