Hi!
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"
id_profile ="1"
current_pressure=121.00
current_temperature=23
Each id_profile defines a correct operation profile with range values. For example
Id_profile="1"
min_pressure=100
max_pressure=150
min_temperature=10
max_temperature=30
Id_profile="2"
min_pressure=104
max_pressure=123
min_temperature=11
max_temperature=34
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!