1) How to integrate Elasticsearch-Hadoop with MySQL DB at the backend and User interface developed in dhtmlx, Spring. 2) Also how to integrate Elasticsearch-Hadoop with Services written in Spring MVC

Elastic Stack Elasticsearch
7

Hi Friends,

I have a problem extracting data from MySQL to Elasticsearch via Logstash.
Suppose I have two different schemas and one table in each of them. Now, we search data from those
tables using a LEFT OUTER JOIN query. How do we configure in the config file.

Schema xyz --> Table1 ; Schema pqr --> Table2 ; joined by a left outer join.
Please suggest ways to extract data from MySQL to elasticsearch using logstash.

Thank you in advance....