How to drop Hive’s default partition (__HIVE_DEFAULT_PARTITION__) with “int” partition column

We know that Hive will create a partition with value “__HIVE_DEFAULT_PARTITION__” when running in dynamic partition mode and the value for the partition key is “null” value. However, depending on on the partition column type, you might not be able to drop those partitions due to restrictions in the Hive …