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);
'SQL > hive' 카테고리의 다른 글
[hive] table, column add comment / add column / change column order / column rename (0) | 2020.06.03 |
---|---|
[hive] partition column rename (0) | 2020.06.03 |
[hive] table rename , change location (0) | 2020.06.01 |