在hive中将多个查询结果拼接成一张表,存入到另一张表中
一、语句
insert into table xiaoyuan_24_traffic_result partition (day_id = '20160506')
select a.phone_id, a.traffic, b.traffic
from (select *
from xiaoyuan_hour_traffic
where day_id = '20160506'
and test_time = '00') a
left join (select *
from xiaoyuan_hour_traffic
where day_id = '20160506'