Getting Results Referencing Multiple Indexs at Once

Hi,

I have 3 CSVs which I use to create 3 indexes. But the problem is the 1st and 3rd Indexes are connected via the 2nd Index (refer to the image)

.

My final result should be A1, A2, A3,B1,B2,B3. How can I get this thing to work?

BR
Rukmal

Elasticsearch does not support joins like a relational database does so you need to reindex your data and create documents the way you want to search and retrieve them, e.g. documents with all fields from the three files.

Hi Christian,

Thank you for the input. The issue I have is, is there a way to use Logstash to put everything to one index based on the relationships, because I am talking about millions of documents (log lines) in 3 CSVs as shown in the above diagram.

What would be the easiest way to get this working?

BR

Yes, you may be able to do this using Logstash, but I would recommend opening a eparate issue under that category.