blob: ff33cb8542521edc8eacadc5c25569767cb96219 (
plain) (
blame)
1
2
3
4
|
insert into plato.Output WITH TRUNCATE
select * from (select lag(data) over w from
(select TableRow() as data, key from plato.Input)
window w as (partition by key)) flatten columns;
|