且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在Hive表格中插入覆盖分区 - 值重复

更新时间: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';