How do i achieve cross join between two types in elasticsearch?

SELECT u.Address,c.locality,jaccard_similarity(u.Address, c.locality) as score  
FROM  users u
left join communites c on jaccard_similarity(u.Address, c.locality) >=0.65

How do I achieve the same functionality in Elasticsearch?

Answers


There is no way to do that natively in elasticsearch.

You'll have to either use nested objects or do application joins ( doing 2 queries in your application).

The documentation will explain the strategies : https://www.elastic.co/guide/en/elasticsearch/guide/current/relations.html


Need Your Help

Java - can't notify a waiting thread?

java multithreading

System.out.println("Thread state: " + threads[i].getState());

How do I import an IIS 6 metabase into iis7?

iis iis-6 iis-7.5 metabase

Before my Windows 2003 box died, I made backups of the Metabase history as well as exported a backup to an MDO file.