Planning to move search functionality to elasticsearch

Elastic Stack Elasticsearch
1

Hi All,

we are building an application with c# web api ,sql server and Angular 5 .So we need to move search functionality to elasticsearch.Actually I have seen Nested objects and Parent child relationship.Which one is better.So the data is keeps on updating.

The sql query is having inner joins and left join, so my question is how to move to elasticsearch?

Thanks in advance,
Kartheek Gummaluri

2

It's preferable to do joins at index time and denormalize your data instead of doing complex things at search time.

Anyway, elasticsearch does not really support joins. But as you saw parent/child is providing that kind of join feature but you should use that after having explored all the other solutions.

3

Ok thanks David Pilato

4

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