Hi All,
Could please confirm if below is possible? If yes please suggest best way to achieve it
Need the ability to create new metadata on top of Elastic documents without having to re-index. The latter is a veeeery slow operation given the amount of data
The metadata needs to be available for joins. Assume I have ingested documents of type Doc with a field name
i. I can create a metadata called mickey, which has a score. I can then do select all Doc d, where d. name=’Joe’ and metadata m.name=’mickey’ and m.parent=d.id and m.score>9
ii. I can create a metadata called mini which has a color. I can then do select all Doc d, where d. name=’Joe’ and metadata m.name=’mini’ m.parent=d.id and m.color=’red’
iii. And I can combine select all Doc d, where d. name=’Joe’ and metadata m, m.name=’mini’ m.parent=d.id and m.color=’red’ and m.score=3