Good Morning Everyone,
So, I am doing some simple tests on Druid and want to query data from multiple data sources, namely, a flow rate sensor and a pressure sensor. I understand JOIN isn’t an option and that I need to use UNION or maybe LOOKUP to do something like this. I have very limited experience with SQL databases and, with the exception of spending a little time with Druid, none with non-relational databases. The data schema is pretty simple, __time, PressureReading and for the flow sensor __time, FlowRate, Totaliser. I want an output of pressureSensor.__time, pressureReading, flowSensor.__time, FlowRate, Totaliser. Anyone willing to share a quick sample of what format I should be using to make UNION (or anything else) work in a case like this? Thank you very much for taking the time to read this. Have a great day!
Abra Controls Corp.