Can we use elasticsearch for relational data use case

Elastic Stack Elasticsearch
1

Hello Team,

Could yo please let me know if i can use Elasticsearch effectively for relational data sue case , where i can make joins and generate metric/visualizations on joined and grouped data.

Elasticsearch Version : 6.3

Thank you,
Aditya

2

Elasticsearch is not a relational data store and does not support joins. In order to use Elasticsearch you will therefore likely need to restructure your data, e.g. through denormalization.