--恢复某个时间点的数据快照
INSERT INTO tem_time
SELECT * FROM Dw_Assess_Agreement AS OF TIMESTAMP TO_TIMESTAMP('2018-04-27 16:20:00', 'YYYY-MM-DD HH24:MI:SS');
表结构修改以及时间过长均会导致快照消失
--恢复某个时间点的数据快照
INSERT INTO tem_time
SELECT * FROM Dw_Assess_Agreement AS OF TIMESTAMP TO_TIMESTAMP('2018-04-27 16:20:00', 'YYYY-MM-DD HH24:MI:SS');
表结构修改以及时间过长均会导致快照消失
转载于:https://my.oschina.net/u/3768722/blog/1808305