0

I'm working with two Elasticsearch indexes -> accounts and contacts. These indexes are related in such a way that each account can be associated to contacts. However, not all contact data is denormalized into the accounts index. Now I need to query accounts and filter the results based on some fields present only in the associated contacts index. This essentially requires a join-like behavior across two indexes.

Constraints:

Both indexes have multiple shards, so I can't use lookup-joins provided by elasticsearch, as it currently supports single shard capability.

I also cannot use data enrichment either because the data in both indexes changes frequently, and keeping enrich policies updated in near real-time is not practical.

A full denormalization isn't ideal either due to data duplication and sync complexity.

Improve this question
2
  • Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Commented Jul 6 at 7:27
  • In your issue Elasticsearch isn't good choice. Try something else Commented Oct 3 at 13:10
Related questions
599
Make elasticsearch only return certain fields?
505
Removing Data From ElasticSearch
503
Explicit vs implicit SQL joins
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.