Hi All, Does anyone have any experience in storing deep, hierarchical relationships in ES?
We are trying to model something along the lines of:
Food -> Fruit -> Green -> Apple Doc
Food -> Fruit -> Round -> Apple Doc
Food -> Healthy -> Apple Doc
Food -> Apple Doc
I want to be able to find the Apple (by some document attributes) but also know that it lives in 2 places (with the hierarchy returned) - ideally with references /snippets to the ancestor documents?
Each of the ancestors in the list are documents in their own rights and I would like to be able to search within any level and find Apple...
Its also worth noting that there are millions of items at each level... so flattening IDs etc is a last resort.