(1)FROM [left_table](3)<join_type> JOIN <right_table> (2)ON <join_condition> (4)WHERE <where_condition> (5)GROUP BY <group_by_list> (6)WITH <CUBE | RollUP> (7)HAVING <having_condition> (10)ORDER BY <order_by_list> 逻辑查询处理阶段简介 FROM：对FROM子句中的前两个...
Hive 中 sql 语句的执行顺序如下:from .. where .. join .. on .. select .. group by .. select .. having .. distinct .. order by .. limit .. union/union all 下面我们通过一个 sql 语句分析下:上面 on是和join连用的, join写在where之前. 你非要这么问, 我只能说on先了, 其实是join.....