且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在没有任何中间文件的情况下创建配置单元表?

更新时间: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;