cx库t3表
hdfs://nameservice1:8020/user/hive/warehouse/cx.db/t3/delta_0000011_0000011_0000
hdfs://nameservice1:8020/user/hive/warehouse/cx.db/t3/delta_0000012_0000012_0000
hdfs://nameservice1:8020/user/hive/warehouse/cx.db/t3/delta_0000014_0000014_0000
hdfs://nameservice1:8020/user/hive/warehouse/cx.db/t3/delta_0000017_0000017_0000
场景一:delete
hdfs://nameservice1:8020/user/hive/warehouse/cx.db/t3/delete_delta_0000013_0000013_0000
hdfs://nameservice1:8020/user/hive/warehouse/cx.db/t3/delete_delta_0000015_0000015_0000
hdfs://nameservice1:8020/user/hive/warehouse/cx.db/t3/delete_delta_0000016_0000016_0000
hdfs://nameservice1:8020/user/hive/warehouse/cx.db/t3/delete_delta_0000018_0000018_0000
hdfs://nameservice1:8020/user/hive/warehouse/cx.db/t3/delta_0000011_0000011_0000
hdfs://nameservice1:8020/user/hive/warehouse/cx.db/t3/delta_0000012_0000012_0000
hdfs://nameservice1:8020/user/hive/warehouse/cx.db/t3/delta_0000014_0000014_0000
hdfs://nameservice1:8020/user/hive/warehouse/cx.db/t3/delta_0000017_0000017_0000
每次删除多一个delete文件夹
想要回滚delete,只需要把对应delete操作产生的文件夹删掉即可
hdfs dfs -rm -r hdfs://nameservice1:8020/user/hive/warehouse/cx/t3/delete_delta_0000018_0000018_0000
场景二:truncate
清空表t3下所有的文件和文件夹
从.Trash找回文件mv到源目录即可
hdfs://nameservice1:8020/user/hive/.Trash/Current/user/hive/warehouse/cx.db/t3
hdfs://nameservice1:8020/user/hive/.Trash/Current/user/hive/warehouse/cx.db/t31614847712686