HIVE Merge Multiple MATCH Conditions

[#1]

Hi Team,

Can you please let us know how to implement the below logic with HIVE merge multiple match actions.

MERGE INTO Target_table AS T

USING Source_Table AS S

ON S.col1=T.col1

WHEN MATCHED THEN UPDATE SET T.col2=S.col2

WHEN MATCHED THEN INSERT VALUES ("DUMMY",S.col2,S.col3)

WHEN NOT MATCHED THEN INSERT VALUES ("NEW",S.col2,S.col3) ;

[#2]

We have to do insert and update on the same table when the condition is MATCHED