Hive查询中的sql语句顺序_hive sql 语法顺序

SELECT [ALL | DISTINCT] select_expr, select_expr, ...
  FROM table_reference    从什么表查
  [WHERE where_condition] 过滤
  [GROUP BY col_list]     分组查询
   [HAVING col_list]      分组后过滤
  [ORDER BY col_list]     排序    统称为hive中4个人
  [CLUSTER BY col_list  
    | [DISTRIBUTE BY col_list] [SORT BY col_list]
  ]
 [LIMIT number]           限制输出的行数
1
2
3
4
5
6
7
8
9
10

select
 count(*)
from join on where group by having order by limit
1
2
3

执行次序：from>join on>where>group by>count(*)>having>select>order by>limit
书写次序：from>join on>where>group by>select>count(*)>having>order by>limit
1
2