Hive使用中经常用到的SQL

1.表创建

1.1方式1

create table  t1(
org_id int,
banner string,
pv int,
uv int)
partitioned by(day_id string) ##分区
row format delimited fields terminated  by '\t'
stored as textfile;

1.2方式2

create table  t2 as select * from t1;

1.3方式3

create table t2 like t1;

2.表数据导出

hdfs dfs -rm /file1/fqw/*
beeline -e "insert overwrite directory '/file1/fqw/' row format delimited fields terminated by '\t' select * from t1"
hdfs dfs -cat /file1/fqw/ >sichuan.txt

3.表数据导入

hdfs dfs -put /file1/fqw/d1.dat /user/hive/warehouse/表名

4.表重命名

alter table oldname rename to newname;

5.表字段修改

alter table