set hive.msck.path.validation=skip;
set hive.mapred.mode=nonstrict;
dfs ${system:test.dfs.mkdir} hdfs:///tmp/temp_table_external/day=¢Bar;
dfs -copyFromLocal ../../data/files/in1.txt hdfs:///tmp/temp_table_external/day=¢Bar;
dfs -ls hdfs:///tmp/temp_table_external/day=¢Bar;

dfs ${system:test.dfs.mkdir} hdfs:///tmp/temp_table_external/day=Foo;
dfs -copyFromLocal ../../data/files/in1.txt hdfs:///tmp/temp_table_external/day=Foo;
dfs -ls hdfs:///tmp/temp_table_external/day=Foo;

dfs -ls hdfs:///tmp/temp_table_external;

create external table table_external (c1 int, c2 int)
partitioned by (day string)
location 'hdfs:///tmp/temp_table_external';

msck repair table table_external;

dfs -ls hdfs:///tmp/temp_table_external;

show partitions table_external;
select * from table_external;

alter table table_external drop partition (day='¢Bar');

show partitions table_external;

drop table table_external;

dfs -rmr hdfs:///tmp/temp_table_external;