hive에서 실행할것. impala에서 하면 실행안됨
ALTER TABLE tmp.table PARTITION (base_dt='20200601') RENAME TO PARTITION (base_dt='2020-06-01')
hadoop distcp /old_dir/base_dt=20200601/* /new_dir/base_dt=2020-06-01/filename
파티션 컬럼 경로 변경
ALTER TABLE tmp.table PARTITION (base_dt='2020-06-01') SET LOCATION '/newdir/base_dt=2020-06-01'
'SQL > hive' 카테고리의 다른 글
| [hive] partition add / delete (0) | 2020.06.04 |
|---|---|
| [hive] table, column add comment / add column / change column order / column rename (0) | 2020.06.03 |
| [hive] table rename , change location (0) | 2020.06.01 |