blob: 014f905280a97b4e82614315e48a6979bdf72664 [file] [log] [blame]
create table dfs.ctas_flatten.`test` as select uid, flatten(lst_lst) lst, flatten(lst_lst[0]) from `data1.json` order by flatten(lst_lst[0]);