[FLINK-30030] Unexpected behavior for overwrite in Hive dialect

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.15.0
• Fix Version/s: 1.16.0, 1.16.1
• Component/s: Connectors / Hive
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: luoyuxia
• Created: 15/Nov/22 13:02
• Updated: 17/Jan/23 01:35
• Resolved: 05/Jan/23 01:42

Description

When overwrite a table in hive dialect, it might not overwrite but to append.

It can reproduce using the following sql:

insert overwrite table `db.tab` values (1, 2) 

only happen when the table is encapsulated by backquote and the table contain two splits with ".".

 

Just find the behavior in hive is also incorrect as reported in HIVE-26741.

Let'us keep to see what's the expected behavior.

Issue Links

• links to: GitHub Pull Request #21326
• links to: GitHub Pull Request #21408