Hive: Add A Partition Only If It Does Not Exist

Alter Partition

  Add Partitions

  ALTER TABLE table_name ADD [IF NOT EXISTS] PARTITION partition_spec [LOCATION 'location1']