hive 如何优雅的将小表扩容十倍。

一 、将所有数据扩容十倍

select concat(joinkey,random),*
from (
select 
joinkey，concat_ws('_','1','2','3','4','5','6','7','8','9','10') ten_number,*
from table 
)t  lateral view explode(split(repeat_number,"_")) table_tmp as random;

二、将joinkey的指定数据扩容十倍

select concat(joinkey,random),*
from (
select joinkey,
case joinkey when'cclovezbf' then concat_ws('_','1','2','3','4','5','6','7','8','9','10') 
else     ""
end as repeat_number,*
from table 
)t  lateral view explode(split(repeat_number,"_")) table_tmp as random;