[HIVE-18801] MERGE INTO SQL not work fully

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.3.2
• Component/s: Clients

Environment

CREATE TABLE transactions(
id int,
name string
)
PARTITIONED BY (partition_date string)
CLUSTERED BY (ID) into 5 buckets
STORED AS ORC TBLPROPERTIES ('transactional'='true');

CREATE TABLE merge_source(
id int,
name string);

• Assignee: Unassigned
• Reporter: xiaolo
• Due: 26/Feb/18
• Created: 26/Feb/18 03:36
• Updated: 26/Feb/18 06:35

Description

Here is three sql:

1:

MERGE INTO transactions AS T 
USING merge_source AS S
ON T.id = S.id
WHEN MATCHED THEN UPDATE SET name='update' ;

2:**

MERGE INTO transactions AS T 
USING merge_source AS S
ON T.id = S.id
WHEN NOT MATCHED THEN INSERT VALUES (S.ID, S.NAME,'321');

3:**

MERGE INTO transactions AS T
USING merge_source AS S
ON T.id = S.id
WHEN MATCHED THEN UPDATE SET name='update'
WHEN NOT MATCHED THEN INSERT VALUES (S.ID, S.NAME,'321');

 

There is no error log , just the table rows is not expected when i run sql3 , it looks like nothing changed.

finally

I need use sql1 and sql2 to replace sql3 , and to make sure the table rows is expected .**