Create a match query in 2 tables with elasticsearch 2.3

Navigation
1

As I can make a query between 2 tables, I have the following tables 

Company:
- id
- name
- domain
- timestamp

Target
- id
- name
- domain
- company
- website
- company_id
- timestamp

User
- id
- firstName
- lastName
- email
- company_id
-timestamp

I need to make a match between the domain of the target and the user's mail belonging to the company.

I'm working on ElasticSearch 2.3 with the elasticsearch-py library with python 2.7

    
asked by Andres Felipe Martinez Cordero 16.11.2016 в 05:35
source

1 answer

1

Unfortunately you can not do what you want in elasticsearch, to solve the problem you have to index the information within the same index as nested documents

    
answered by 15.02.2017 в 09:30
Divide text into two div Help with clause Where in MySQL and PHP for android