常用的hive语句

创建分区表
create table one(id int comment 'the id',name string comment 'the name',age int comment 'the age') 
partitioned by(part string)
row format delimited fields terminated by ','stored as textfile;
往分区表中添加数据
load data inpath '/data.txt' into table one partition(part=1);

添加列
alter table one add columns (hoby string comment 'aihao');

给分区表添加分区
alter table one add partition(part=2);

删除分区
alter table one drop partition (part=2);

修改表名称
alter table one rename to wxz_one;

把一个表查询的数据插入到另一张表中
insert into table t_one partition(dt='10')
select id,name,age,hoby from wxz_one;

//把查询出来的数据保存到本地的/home/one下
insert overwrite local directory '/home/one' 
select * from t_one;

//把查询出的数据保存到hdfs目录下
insert overwrite directory 'hdfs://192.168.150.100:9000/one'
select * from t_one