I've understood that join and lookup are very complex problems in NoSQL technologies.
Neverthless,I need of help.
I have a list of events that are indexed in elasticsearch. For example:
id_product = "152t36"
Each id_profile defines a correct operation profile with range values. For example
I need of a query that signal all devices that have values out of range.
What's the best strategy?
If I index also correct operation profile, how can I join profiles and make the necessary controls?
Thank you very much!