Hive SQL的执行流程

执行计划

执行计划官网介绍

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Explain

select

select a.id, a.city, a.cate from access a 
where a.day='20190414' and a.cate='大奔'   
没有shuffle、仅仅就是过滤而已

group by 

select city, count(1) cnt from access  
where day='20190414' and cate='大奔'
group by city

 

转载于:https://my.oschina.net/u/4005872/blog/3039616