blob: f6c1f2b2aa3f9ae85deb5f31e3c20586f31a54e2 [file]
create table dfs.ctas_flatten.`functions1_ctas` as select MAX(sub.val) from (select flatten(d.lst_lst[0]) val from `data1.json` d) sub;
select * from dfs.ctas_flatten.`functions1_ctas`;
drop table dfs.ctas_flatten.`functions1_ctas`;