报表需求复盘

一、关于hive
什么是小表 Join 大表？ < 5%
查看分区 show partitions db.table;
查看建表语句 show create table db.table;
Ask：t1 join t2 left join t3 on t1.id=t3.id 和 t1 join t2 left join t3 on t2.id=t3.id 有不同吗？

结果是一样的，华南省。且执行计划也是一样的。

select t3.area_name
from (select '西北省' as area_name
union all
select '华南省' as area_name) t1 join (select '华东省' as area_name
union all
select '华南省' as area_name) t2 on t1.area_name=t2.area_name
left join (select '华东省' as area_name
union all
select '华南省' as area_name) t3 on t1.area_name=t3.area_name;--t1.area_name=t3.area_name

Explain String	
Max Per-Host Resource Reservation: Memory=3.88MB	
Per-Host Resource Estimates: Memory=10.00MB	
Codegen disabled by planner	
	
PLAN-ROOT SINK	
|	
04:HASH JOIN [LEFT OUTER JOIN, BROADCAST]	
|  hash predicates: area_name = area_name	
|	
|--06:EXCHANGE [UNPARTITIONED]	
|  |	
|  02:UNION	
|     constant-operands=2	
|	
03:HASH JOIN [INNER JOIN, BROADCAST]	
|  hash predicates: area_name = area_name	
|	
|--05:EXCHANGE [UNPARTITIONED]	
|  |	
|  01:UNION	
|     constant-operands=2	
|	
00:UNION	
   constant-operands=2	

关于Impala
一步一步理解Impala query profile（一）
一步一步理解Impala query profile（二）
一步一步理解Impala query profile（三）
一步一步理解Impala query profile（四）