Joining two files in elasticsearch

Elastic Stack Elasticsearch
1

Hi

I want to index two files and after that I wanted to join the result from both the files.

Suppose I have one or more common columns in both the files and have no of columns which are different in both the files. but while retrieving or visualizing the data in kibana, I wanted to the show result on basis of common columns just like the join queries in RDBMS.

Is it possible in Elasticsearch & kibana??

Thanks in advance.

2

Hi,

I don't understand everything you want, maybe "terms aggregation" for the common column (field in Elasticsearch) support you.

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html

3

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