2

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 ?

sumanth232
  • 587
  • 7
  • 20

2 Answers2

4

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.

cberner
  • 3,000
  • 3
  • 22
  • 34
  • Has anybody written such a connector ? any links to help writing such a connector would help. – sumanth232 Jun 02 '15 at 09:05
  • I don't know of an ElasticSearch connector, but take a look at the jdbc connector and the example http connector. They're both in the main presto repository – cberner Jun 02 '15 at 15:55
0

There is a Hive ElastiSearch connector.

Presto can work over Hive metastore

UPDATE

This doesn't work

Alex Stanovsky
  • 1,286
  • 1
  • 13
  • 28