How to find common entries from two indices using Kibana



I have two indices like "indexA" and "indexB". There is a field "linkdata" in these indices, which is a string, which acts as a foreign key to link between these two indices. Not always it acts as a foreign key, but sometimes, the entry in both indices will be same. I want to identify those data (linkdata strings), which is common to both indices. How can I do this in Kibana?

Thank you.

(Lukas Olson) #2

I'm pretty sure it will be difficult to accomplish what you're trying to, as Elasticsearch isn't really set up to have separate indices with foreign keys. But what exactly are you trying to accomplish? Are you trying to get a list of results with each row corresponding to the results of both linked documents? Or are you trying to create some sort of visualization with the linked data?

(Mark Walkom) #3

This is a join, you cannot do that in ES.

(system) #4