1 hive的 链接 left out join 的时候
====================================正确=================================================
select sum(a.assistant_total_project ) from (select * from dw_cds.c_enterprise_active_hbase_daily where day ='20160912' ) a
LEFT OUTER JOIN (select * from dw_bds_m.m_pub_enterprise_info where dt='20160912' and run_status =2 )b
on a.enterprise_id =b.eid
====================================错误=================================================
select sum(a.assistant_total_project ) from dw_cds.c_enterprise_active_hbase_daily a
LEFT OUTER JOIN dw_bds_m.m_pub_enterprise_info b
on a.enterprise_id =b.eid and day ='20160912' and dt='20160912' and run_status =2
====================================结论=================================================
=====================================================================================