[HIVE-15307] Hive MERGE: "when matched then update" allows invalid column names.

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.2.0
• Component/s: Transactions
• Target Version/s: 2.2.0
• Assignee: Eugene Koifman
• Reporter: Eugene Koifman
• Created: 29/Nov/16 19:38
• Updated: 01/Oct/19 22:06
• Resolved: 08/Dec/16 02:14

Description

create table target (
  id int, val int
)
CLUSTERED BY (id) INTO 2 BUCKETS STORED AS ORC TBLPROPERTIES ("transactional"="true");

create table source2 (
  id int, val int
);
insert into source2 values (2, 25), (3, 35), (4, 45);

merge into target
using source2 sub on sub.id = target.id
when matched then update set invalid = sub.val;