Using peach
and unionAll
, we can reconstruct the original table:
unionAll(peach(x->table(take(x.ticker, size(x.volume_all)) as ticker, x.volume_all as volume), t1), false)
In the code, peach
performs parallel processing: it applies an anonymous function (x -> ...
) to each row of t1
, expanding the grouped ticker
and volume_all
arrays into multiple rows. unionAll
: Combines all temporary tables into a single result.