https://cwiki.apache.org/confluence/display/Hive/Home#Home-GeneralInformationaboutHive
https://cwiki.apache.org/confluence/display/Hive/LanguageManual
首页
语法手册
1. 命令行与客户端
1.1 数据类型
- 数据类型转换(Change Types)
- 数据类型隐式转换矩阵(Allowed Implicit Conversions)
1.2 参数配置
- 常用参数配置
1.3 select语法
- All and DISTINCT 语句，UNION语句可以有相同效果
- Partition Based Queries
- HAVING Clause
- REGEX Column Specification
- GROUP BY
- SORT/ORDER/CLUSTER/DISTRIBUTE BY
- JOIN
- UNION
- TABLESAMPLE
- Subqueries
- Virtual Columns
- Operators and UDFs hive函数
- LATERAL VIEW
- Windowing, OVER, and Analytics
- Common Table Expressions 临时表语法