How To Pass Elasticsearch Query To Hadoop

I am working on a project to allow searching on Hadoop. How it works is the query is first passed to ES, then the resulting IDs are passed back to SQL, like so: SELECT ... WHERE id

Solution 1:

Insert all elastic search ids in to a separate table then join it with source table.

e.g.

CREATETABLE ELASTIC_SEARCH_ID(id INT);

SELECT ... FROM SOURCE S JOIN ELASTIC_SEARCH_ID ES ON S.ID=ES.ID;