set hive.msck.repair.batch.size=2;

DROP TABLE IF EXISTS repairtable_n0;

CREATE TABLE repairtable_n0(col STRING) PARTITIONED BY (p1 STRING, p2 STRING);

MSCK TABLE repairtable_n0;

dfs ${system:test.dfs.mkdir} ${system:test.local.warehouse.dir}/repairtable_n0/p1=a/p2=a;
dfs ${system:test.dfs.mkdir} ${system:test.local.warehouse.dir}/repairtable_n0/p1=b/p2=a;
dfs ${system:test.dfs.mkdir} ${system:test.local.warehouse.dir}/repairtable_n0/p1=c/p2=a;
dfs -touchz ${system:test.local.warehouse.dir}/repairtable_n0/p1=a/p2=a/datafile;
dfs -touchz ${system:test.local.warehouse.dir}/repairtable_n0/p1=b/p2=a/datafile;
dfs -touchz ${system:test.local.warehouse.dir}/repairtable_n0/p1=c/p2=a/datafile;

MSCK TABLE default.repairtable_n0;
show partitions default.repairtable_n0;

MSCK REPAIR TABLE default.repairtable_n0;
show partitions default.repairtable_n0;

MSCK TABLE repairtable_n0;
show partitions repairtable_n0;

DROP TABLE default.repairtable_n0;


dfs  ${system:test.dfs.mkdir} -p ${system:test.tmp.dir}/apps/hive/warehouse/test.db/repairtable_n0/p1=c/p2=a/p3=b;
CREATE TABLE `repairtable_n0`( `col` string) PARTITIONED BY (  `p1` string,  `p2` string) location '${system:test.tmp.dir}/apps/hive/warehouse/test.db/repairtable_n0/';

dfs -touchz ${system:test.tmp.dir}/apps/hive/warehouse/test.db/repairtable_n0/p1=c/p2=a/p3=b/datafile;
set hive.mv.files.thread=1;
MSCK TABLE repairtable_n0;
show partitions repairtable_n0;

DROP TABLE default.repairtable_n0;