CODE EXAMPLE FOR SQL

alter table drop partition hive

ALTER TABLE some_table DROP IF EXISTS PARTITION(year = 2012)