[HIVE-21462] Upgrading SQL server backed metastore when changing data type of a column with constraints

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Standalone Metastore
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Hadoop Flags: Reviewed
• Assignee: Ashutosh Bapat
• Reporter: Ashutosh Bapat
• Created: 18/Mar/19 04:45
• Updated: 01/Dec/22 09:26
• Resolved: 22/Mar/19 06:39

Description

SQL server does not allow changing data type of a column which has a constraint or an index on it. The constraint or the index needs to be dropped before changing the data type and needs to be recreated after that. Metastore upgrade scripts aren't doing this and thus upgrade fails.

Issue Links

• is cloned by: HIVE-26800 Backport HIVE-21755 : Upgrading SQL server backed metastore when changing
• links to: GitHub Pull Request #573