hive官网:http://hive.apache.org/
>hive wiki>User Documentation
SQL:DDL DML
DDL:create delete alter
DML: SQL
1
调整Hive 数据存放的HDFS的路径
hive wiki==>User Documentation==>Hive Configuration Properties==>
搜索hive.metastore.warehouse.dir==>到/home/hadoop/app/hive/conf/hive-site.xml==>配置如果要调整,就把这个参数设置到hive-site.xml中去
hive.metastore.warehouse.dir
xxxx
2
展示数据库的名字
3
打印查询输出中列的名称
搜索hive.cli.print.current.db==>到/home/hadoop/app/hive/conf/hive-site.xml==>配置如果要调整,就把这个参数设置到hive-site.xml中去
hive.cli.print.current.db
true
搜索hive.cli.print.header==>到/home/hadoop/app/hive/conf/hive-site.xml==>配置如果要调整,就把这个参数设置到hive-site.xml中去
hive.cli.print.header
true
4
hivewiki==>UserDocumentation==>DDL==>create/drop/alter/truncate/show/describe==>创建修改库/表都在这里
5
hivewiki==>UserDocumentation==>Data Types(数据类型)
6
hivewiki==>UserDocumentation==>DML(表相关的,导数据到hive里面等等)
7
官网关于内部表和外部表的解释hivewiki==>UserDocumentation==>DDL==>create/drop/alter/truncate/show/describe==>Create/Drop/Truncate Table==>External Tables==>Managed and External Tables
8
选择性查询
hivewiki==>UserDocumentation==>DML==>Queries (select)
9
日期函数
ivewiki==>UserDocumentation==>DML==>Operators and UDFs==>Date Functions
10窗口分析函数
hivewiki==>UserDocumentation==>DML==>Queries (select)> Windowing, OVER, and Analytics
11 恢复分区
hivewiki>UserDocumentation==>DDL==>Alter Table/Partition/Column==>Recover Partitions (MSCK REPAIR TABLE)