Hive_03 Hive on Hadoop执行流程

常用的SQL不外乎分为两种

	select yyy, 聚合函数  from xxx group by yyy;
	select a.*, b.* from a join b on a.id=b.id;

		 SQL		     AST				 QB			    	   Operator Tree					  Operator Tree		        	  Task Tree				    		Task Tree	
      ========> Parser ========> Analyzer =========> Logical Plan ===============> Logical Optimizer ===============> Physical Plan =============> Physical Optimizer ===============>	提交运行

1. Parser(解析器) SQL==>AST(抽象语法树)(字符串)
2. Analyzer(分析器) AST ===> QB (query block)
3. Logic Plan(逻辑执行计划) QB ===> Operator Tree
4. Logic Optimizer(逻辑优化) Operator Tree ===> Operator Tree
5. Physical Plan(物理执行计划) Operator Tree ===> Task Tree
6. Physical Optimizer(物理优化)

简单来说，就是SQL(字符串)通过解析分解、逻辑执行及优化、物理执行及优化 生成作业。