修改表
增加分区:
ALTER TABLE table_ name ADD PARITION(dt='20170101') location
'/user/hadoop/warehouse/table_ name/dt=20170101';//一次添加一个分区
ALTER TABLE table_ name ADD PARTITION (dt='2008-08-08', country='us') location
'/path/to/us/part080808' PARTITION (dt='2008-08-09', country='us') location
'/path/to/us/part080809'; //- 次添加多 个分区
删除分区
ALTER TABLE table_ name DROP IF EXISTS PARTITION (dt='2008-08-08');
ALTER TABLE table_ name DROP IF EXISTS PARTITION (dt='2008-08-08', country='us');
修改分区
ALTER TABLE table_name PARTITION (dt='2008-08-08) RENAME TO PARTITION (dt= 20080808');
添加列
//ADD是代表新增一个字段,新增字段位置在所有列后面(partition列前
//REPLACE则是表示替换表中所有字段
ALTER TABLE table_name ADDIREPLACE COLUMNS (col_name STRING);
修改列
test_change(a int,b int,c int);
alter table test_change change a a1 int;//修改a字段名
//will change column a's name to a1 a's data type to string,and put it after column b. The new table's structure is:b int,a1 string,c int
alter table test_change change a a1 string after b;
//will change column b's name to b1,and put it as the first column. The new table's structure is:b1 int,a ints,c int
alter table test_change change b b1 int first;
表重命名
alter table table_name rename to new_table_name
查询表
//显示当前数据库所有表
show tables;
//显示所有数据库
show databases | schemas;
//显示表分区信息,不是分区表执行标错
show partitions 表名;
//显示当前版本hive支持的多有方法
show function;
//查看表信息
desc extended 表名;
//查看表信息(格式化美观)
desc formatted 表名;
//查看数据库相关信息
describe database 数据库名;