We are implementing "Elastic Search" in our one of the project in .NET. We have already started the implementing. But somehow between it, we are facing some issues.
We have transferred our SQL database to the Elastic Search's Database, and also we are getting records using it.
But further, We wants to get records from multiple tables, and also want to make joins between them. But We are unable to find any tutorial/reference regarding this for Elastic Search.
So can you please guide us how to make joins between tables in Elastic Search, and get records from multiple tables.
Please help us into this concern, so we can go further with implementing Elastic Search into our Project.
Elasticsearch is not a relational data store and does not support joins. You are therefore very likely to need to change how you model data when you move from a relational database. This often means denormalising the data, but there are a few other features that can help in certain circumstances. This is described in the Elasticsearch - the Definitive Guide, which I would recommend reading.
WE are implementing the Elastic search in our .net project which is of nopCommerce 3.7(Open cart in .NET). In this, all the Stored Procedure and queries are predefined, and some are developed and customized by us. So it will become very time consuming and complex. So do you have any idea how we can implement the functionality of Elastic Search into nopCommerce 3.7?
Can you please guide us how can we implement this type of functionality? Hope you know about nopCommerce, so you can guide us in better way.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.