Is JOIN operation possible in ElasticSearch using any ES Connector for presto or Hive (ElasticSearch-Hadoop)?

Question

As we know that JOIN operation is not possible in ElasticSearch among indices, Can it be achieved using Presto or Hive, i.e. can we do a JOIN operation using any ElasticSearch Connector for Presto or Hive ?

Can we do JOIN in ElasticSearch using ElasticSearch-Hadoop - https://github.com/elastic/elasticsearch-hadoop ?

Answer 1

Yes, if you write a connector for ElasticSearch to Presto, you can use it to do JOINs. JOINs in Presto are processed inside the core engine, and don't involve the connector, except to read the underlying data.

Answer 2

There is a Hive ElastiSearch connector.

Presto can work over Hive metastore

UPDATE

This doesn't work