内部、外部分区表

内部分区表：
create table partable(id string,age string)
partitioned by (city string,dt string)
row format delimited
fields terminated by ','
stored as textfile;



alter table partable add partition(city='shanghai',dt='2014-01');

load data local inpath '/home/upsmart/mytest/11'
overwrite into table partable partition(city='shanghai',dt='2014-01');


alter table partable add partition(city='shanghai',dt='2014-02');

load data local inpath '/home/upsmart/mytest/testpar/11'
into table partable partition(city='shanghai',dt='2014-02');

alter table partable add partition(city='shanghai',dt='2014-03');

load data local inpath '/home/upsmart/mytest/testpar'
into table partable partition(city='shanghai',dt='2014-03');


外部分区表：
create external table outtmp(id string,age string)
partitioned by (city string,dt string)
row format delimited
fields terminated by ','
stored as textfile
location '/outtmp';


alter table outtmp add partition(city='shanghai',dt='2014-01') location 'shanghai/2014-01';

alter table outtmp add partition(city='shanghai',dt='2014-02') location 'shanghai/2014-02';