Can we perform joins on the Indexes in ES?


I have shipped data from sql server to ES using logstash. I have created two indexes in Kibana,. I just want to join two documents to get required results.

Elasticsearch and Kibana does not support joins, so when working with relational data it is generally recommended to denormalise data into entities that match what you will be searching for before you ingest the data. If you can provide a bit more information about your data and how you want to query it, someone might be able to help come up with a solution.

Lack of joins/subqueries/sequential queries is the biggest flaw in Elastic. (Yes, they're expensive, but forcing users to work around that is annoying and even more expensive.)

@manjur - another option is to script some queries at the API. You can can than use the results of the first query to build the second (which is all a sub query is doing under the hood). This works pretty well if your data isn't something that de-normalizes well.

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