DROP TABLE IF EXISTS repairtable_n4;

CREATE EXTERNAL TABLE repairtable_n4(key INT, value STRING) PARTITIONED BY (Year INT, Month INT, Day INT) stored as ORC;

MSCK REPAIR TABLE repairtable_n4;
show partitions repairtable_n4;

dfs ${system:test.dfs.mkdir} ${system:test.local.warehouse.dir}/repairtable_n4/Year=2020/Month=3/Day=1;
dfs ${system:test.dfs.mkdir} ${system:test.local.warehouse.dir}/repairtable_n4/Year=2020/Month=3/Day=2;

MSCK REPAIR TABLE repairtable_n4;
show partitions repairtable_n4;

DROP TABLE default.repairtable_n4;