Hive MERGE Failure Due to Partition Column in SCD Type-2 Implementation

Dears,

The Hive MERGE is failing with the error below. Since yearmonth is a partition column, implemented a Type-2 SCD script to track changes. However, even after including the partition column in the join condition, the same error persists.

Error while compiling statement: FAILED: SemanticException [Error 10007]: Ambiguous column reference deal_yearnumber in tgt.

Script

MERGE INTO accrued_interest_metric tgt
USING temp_ACCRUED_INTEREST_METRIC src
ON tgt.deal_number = src.deal_number
AND tgt.deal_metric_end_date = DATE '9999-12-31'
WHEN MATCHED
AND tgt.deal_hash <> src.deal_hash
THEN UPDATE SET
deal_metric_end_date = CURRENT_DATE - 1,
update_date = current_timestamp()
WHEN NOT MATCHED THEN
INSERT (
deal_number,
deal_metric_start_date,
deal_metric_end_date,
deal_branch_cd,
deal_type_cd,
deal_reference_number,
currency_cd,
deal_maturity_date,
deal_last_rollover_date,
deal_next_rollover_date,
deal_term_type_cd,
deal_accrued_interest_rate,
status_cd,
status_description,
deal_account_number,
deal_interset_account_number,
period_type_cd,
interset_type_cd,
deal_hash,
insert_date,
update_date,
deal_yyyymm
)
VALUES (
src.deal_number,
src.deal_metric_start_date,
src.deal_metric_end_date,
src.deal_branch_cd,
src.deal_type_cd,
src.deal_reference_number,
src.currency_cd,
src.deal_maturity_date,
src.deal_last_rollover_date,
src.deal_next_rollover_date,
src.deal_term_type_cd,
src.deal_accrued_interest_rate,
src.status_cd,
src.status_description,
src.deal_account_number,
src.deal_interset_account_number,
src.period_type_cd,
src.interset_type_cd,
src.deal_hash,
current_timestamp(),
current_timestamp(),
src.src_deal_yyyymm
);