Hive运维记之-补分区表数据
1、首先将数据导入一个临时表分区
LOAD DATA INPATH 'hdfs://nwdservice/user/datamart/logdata/log-1472464800000/part-00000' OVERWRITE into TABLE log.user_log PARTITION (p_day='2016-07-32');
LOAD DATA INPATH 'hdfs://nwdservice/user/datamart/logdata/log-1472464800000/part-00001' into TABLE log.user_log PARTITION (p_day='2016-07-32');
LOAD DATA INPATH 'hdfs://nwdservice/user/datamart/logdata/log-1472464800000/part-00002' into TABLE log.user_log PARTITION (p_day='2016-07-32');
LOAD DATA INPATH 'hdfs://nwdservice/user/datamart/logdata/log-1472464800000/part-00003' into TABLE log.user_log PARTITION (p_day='2016-07-32');
LOAD DATA INPATH 'hdfs://nwdservice/user/datamart/logdata/log-1472464800000/part-00004' into TABLE log.user_log PARTITION (p_day='2016-07-32');
LOAD DATA INPATH 'hdfs://nwdservice/user/data