| DROP TABLE IF EXISTS repairtable_n6; |
| |
| CREATE EXTERNAL TABLE repairtable_n6(key INT, value STRING) PARTITIONED BY (Year INT, Month INT, Day INT) stored as ORC location '${system:test.tmp.dir}/apps/hive/warehouse/test.db/Repairtable_n6/'; |
| |
| MSCK REPAIR TABLE repairtable_n6; |
| show partitions repairtable_n6; |
| |
| dfs ${system:test.dfs.mkdir} -p ${system:test.tmp.dir}/apps/hive/warehouse/test.db/Repairtable_n6/Year=2020/Month=4/Day=1; |
| |
| MSCK REPAIR TABLE repairtable_n6; |
| show partitions repairtable_n6; |
| |
| DROP TABLE default.repairtable_n6; |