I have two mysql tables containing thousands of rows in each table. I have index all records into elasticsearch using logstash jdbc plugin.
The Idea is to compare difference between two tables using Elasticsearch in a very fast manner. Faster than SQL.
I have index called elasticdata and two documents type table1 and table2.
I have to compare each column1 of table1 document type with all rows of table2 ducument type. If diference is foud print the value.
How it can be achived in elastic search. Please suggest.