본문 바로가기

SQL/hive

[hive] partition add / delete

ALTER TABLE tmp.table ADD IF NOT EXISTS PARTITION (base_dt='2020-06-01')

 

ALTER TABLE tmp.tableDROP IF EXISTS PARTITION(year = 2012, month = 12, day = 18);