日常用到hive sql做个总结
hive创建表
create table if not exists register
(
user_id bigint,
type string,
s1 string,
s2 string,
s3 string,
s4 string,
stage int,
from_id bigint
)partitioned by(dt string)
row format delimited fields terminated by '\t' lines terminated by '\n';
删除表
drop table register_daily
通过本地文件添加分区
hive -e "load data local inpath './reg_2013-07-25' overwrite into table register partition(dt='2013-07-25');"
删除分区
alter table register drop partition (dt='2013-07-25');
通过集群文件创建分区
alter table register add partition (dt='2013-07-25') location '/user/hive/warehouse/register_daily/dt=2013-07-25';
表名重命名
alter table register rename to t_register_daily;
列名重命名,修改数据类型
alter table t_register_daily change from_id fromid string;
添加新的列
alter table t_register_daily add columns (appid int);