我相信这应该管用。
只需将源表列别名为目标列名。

set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;

INSERT OVERWRITE TABLE target_external_table PARTITION(YEAR,MONTH,DAY) --check partition order in your table. I believe this is the order.
SELECT
    UPDATED_BY,
    abc AS name,
    YEAR,
    MONTH,
    DAY
FROM source_table;