[HIVE-26130] Incorrect matching of external table when validating NOT NULL constraints

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.0.0-alpha-1, 4.0.0-alpha-2
• Labels: pull-request-available
• Assignee: Butao Zhang
• Reporter: Butao Zhang
• Created: 11/Apr/22 09:23
• Updated: 21/Oct/22 07:31

Description

AbstractAlterTablePropertiesAnalyzer.validate uses incorrect external table judgment statement:

else if (entry.getKey().equals("external") && entry.getValue().equals("true") 

In current hive code, we use hive tblproperties('EXTERNAL'='true' or 'EXTERNAL'='TRUE) to validate external table.

 

Issue Links

• is related to: HIVE-18598 Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL table
• links to: GitHub Pull Request #3199