I have two arrays. Their elements are correlated times and values. I
would like to flatten them into rows, each with two elements.
The query
select flatten(a), flatten(b) from ...
doesn't work because I get the cartesian product (of course). The query
select flatten(a, b) from ...
also doesn't work because flatten doesn't have a multi-argument form.
Going crazy, this query kind of sort of almost works, but not really:
select r.x.`key`, flatten(r.x.`value`) from (
select flatten(kvgen(x)) as x from ...) r;
What I really want to see is something like this:
select zip(flatten(a), flatten(b)) from ...
Any pointers? Is my next step to write a UDF?
