Hive一条SQL使用随机值创建测试表一百万条数据

找一个1000条数据的表，例如表large01,利用left join通过表的笛卡尔积插入，1000 left join 1000 为 1000000,若初始表只有十条数据，无非是多left join几次；同理更大批量数据也可以实现

create table  test_table_100w as
select 
row_number() over(order by 1) as id,
substr(concat('',rand()),3) as number_str,
from_unixtime(unix_timestamp(),'yyyy-MM-dd HH:dd:ss') as str_datetime,
from_unixtime(unix_timestamp()+ row_number() over(order by 1),'yyyy-MM-dd HH:dd:ss') as str_datetime_add,
from_unixtime(unix_timestamp(),'yyyy-MM-dd') as str_date,
date_add(concat('',from_unixtime(unix_timestamp(), 'yyyy-MM-dd')),(row_number() over(order by 1))/10000) as date_add,
date_sub(concat('',from_unixtime(unix_timestamp(), 'yyyy-MM-dd')),(row_number() over(order by 1))/10000) as date_sub,
concat('随机字段值', substr(concat('',rand()),3)) as random_string0,
concat('随机字段值', substr(concat('',rand()),3)) as random_string1,
concat('随机字段值',substr(concat('',rand()),3)) as random_string2,
concat('随机字段值', substr(concat('',rand()),3)) as random_string3,
concat('随机字段值', substr(concat('',rand()),3)) as random_string4,
concat('随机字段值', substr(concat('',rand()),3)) as random_string5,
concat('随机字段值', substr(concat('',rand()),3)) as random_string6,
concat('随机字段值', substr(concat('',rand()),3)) as random_string7,
concat('随机字段值', substr(concat('',rand()),3)) as random_string8,
concat('随机字段值', substr(concat('',rand()),3)) as random_string9,
'' as description
from (select '' from large01 limit 1000) as t1  left join (select '' from large01 limit 1000) as t2 on 1=1;