I want to join table in mysql database with elasticsearch index document.
For ex: I want to fetch log related to user.
Logs are store on elastic search unsed userlog dcoument, which is having userID attribute.
And user details store in "USER" on MYSQL databse.
I want to join user table with index to display log with user name and some other details from user table and log from elasticsearch.
Please help me to achieve this.