[FLINK-30567] Wrong insert overwrite behavior when the table contains uppercase character with Hive dialect

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.16.0, 1.16.1
• Fix Version/s: 1.17.0, 1.16.2
• Labels: pull-request-available
• Assignee: luoyuxia
• Reporter: luoyuxia
• Created: 05/Jan/23 04:16
• Updated: 01/Feb/23 13:45
• Resolved: 30/Jan/23 03:28

Description

If use hive dialect, the data would be wrong if we rerun the following job multiple tables.

INSERT overwrite TABLE db_name.target_tB_name partition(p_date = '20230101')
select 
author_id
from db_name.source_tb_name
WHERE p_date = '20230101'
and author_id <> '0'

The framework has a minor bug when determining whether an override is required if the target name contains uppercase character.

Issue Links

• links to: GitHub Pull Request #21602