文章目录
3、右外连接(RIGHT OUTER JOIN)
4、满外连接(FULL OUTER JOIN)
2、Sort By-每个MapReduce内部局部排序
hive查询语法
一、SELECT语句
1、语句结构
基本语法:
SELECT [ALL | DISTINCT]select_expr, select_expr, ...
FROM table_reference
[WHERE where_condition]
[GROUP BY col_list]
[HAVING where_condition]
[ORDER BY col_list]
[CLUSTER BY col_list
| [DISTRIBUTE BY col_list] [SORT BY col_list]
]
[LIMIT number]
1、