e.g.,
SELECT device_id, timevector(ts, val) -> sort() -> delta() -> abs() -> sum() as volatility
Oh or I see timevector returns a custom datatype, so I suppose the answer is it has to be one of a fixed number of provided types?
Exactly! These aren't general arithmetic operators, they're specifically for mapping arithmetic operations over timevectors.
We're planning on providing various outputs, json is definitely one format we'd want to support, want to file a github issue with the layout that you'd want and we can start getting some feedback to implement?
e.g.,