aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/insert/after_group_by.sql
blob: c2abecae3647b29b37d16a9a9297af15b6b035b0 (plain) (blame)
1
2
-- kikimr only: pragma kikimr.UnwrapReadTableValues = "false"; create table plato.Output (key varchar null, subkey varchar null, value varchar null, primary key (key)); commit;
insert into plato.Output (key, subkey, value) select key, subkey, max(value) from plato.Input group by key, subkey order by key;