更新时间:2022-10-17 23:27:49
It seems like you forgot the WHERE clause in your last INSERT OVERWRITE:
INSERT INTO TABLE Unm_Parti_Trail PARTITION (Department = 'A')
SELECT employeeid,firstname,designation, CASE WHEN employeeid=19
THEN 50000 ELSE salary END AS salary FROM Unm_Parti_Trail
WHERE department = 'A';