大数据学习——hive数仓DML和DDL操作

create table t_partition001(ip string,duration int)
partitioned by(country string)
row format delimited
fields terminated by ',';

load data local inpath '/root/hivedata/t_partitioned' into table t_partition001 partition(country="China");

alter table t_partition001 add partition(country="Japan");

 load data local inpath '/root/hivedata/t_partitioned' into table t_partition001 partition(country="Japan");

 alter table t_partition001 rename to t_partition002;

 alter table t_partition002 add columns(city string);

alter table t_partition002 replace columns(name string);