拉链表dwd_userinfo_db,目前时间是2020-12-15,想回滚到2020-11-27,那么拉链表的状态得是2020-11-26
userid starttime endtime
1 2020-11-12 2020-11-26
1 2020-11-27 9999-99-99
2 2020-11-16 2020-12-13
2 2020-12-14 9999-99-99
拉链表回滚:过滤starttime<=2020-11-26的数据,将endtime>=2020-11-26的修改为9999-99-99
insert overwrite table dwd_userinfo_db
select
userid,
starttime,
if(endtime>=2020-11-26,'9999-99-99',endtime)
from dwd_userinfo_db
where starttime<=2020-11-26