思路:一次扫描 多次插入
简称:多重插入
普通插入:
insert into table test_insert1 select id from source_table;
insert into table test_insert2 select name from source_table;
多重插入:
from source_table
insert overwrite table test_insert1
select id
insert overwrite table test_insert2
select name;