drop table score5;
直接向分区表中插入数据
create table score3 like score;
insert into table score3 partition(month ='201807') values ('001','002','100');
通过查询插入数据 通过load方式加载数据
load data local inpath '/export/servers/hivedatas/score.csv' overwrite into table score partition **
通过查询方式加载数据
create table score4 like score;
insert overwrite table score4 partition(month = '201806') select s_id,c_id,s_score from score;