C6_impala生产上操作,测试类似
T分区,找到最新分区15分区(也就是当日),然后操作如下:
1、13分区s层 location /a
alter table sdl.s_mbp_mgd_t_prototype_deliver_subitem_n partition(dt=20211213) set location
‘hdfs://nameservice1/user/hive/warehouse/sdl.db/s_mbp_mgd_t_prototype_deliver_subitem_n/dt=20211213abc’;
2、跑14分区全量b-o-s调度
3、跑15分区s
4、改回来13分区location,并刷新
alter table sdl.s_mbp_mgd_t_prototype_deliver_subitem_n partition(dt=20211213) set location
‘hdfs://nameservice1/user/hive/warehouse/sdl.db/s_mbp_mgd_t_prototype_deliver_subitem_n/dt=20211213’;
#刷新
refresh sdl.s_mbp_mgd_t_prototype_deliver_subitem_n;