SET hive.metastore.partition.name.whitelist.pattern=[A-Za-z]*; -- This pattern matches only letters. CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING); SHOW PARTITIONS part_whitelist_test; ALTER TABLE part_whitelist_test ADD PARTITION (ds='Part');