explain

在hive执行时，想看具体执行任务，可以用explain
explain create table bdm_gemini.tmp_dp_feature6_pc_year
as 
select a.gid1, b.cid, sum(b.cnt) from 
(
select gid1 from bdm.gemini_training_distinguished
where create_date>='2016-07-01' and create_date<='2016-07-31'
group by gid1
) a 
left join 
(
select * from bdm.tmp_dp_feature_class4_test_pre
where l_date>='2015-08-01' and l_date<'2016-08-01'
) b 
on a.gid1=b.gid
group by a.gid1, b.cid;