更新时间:2022-05-30 22:12:59
create table my_table(id int, value int);
insert overwrite table my_table
select a.id as id, b.value as value from (
select count(*) from my_table
) t
lateral view explode(array(1,2,3)) a as id
lateral view explode(array(2,3,5)) b as value;