Ashutosh Bapat created HIVE-21462:
-------------------------------------
Summary: Upgrading SQL server backed metastore when changing data
type of a column with constraints
Key: HIVE-21462
URL: https://issues.apache.org/jira/browse/HIVE-21462
Project: Hive
Issue Type: Bug
Components: Standalone Metastore
Reporter: Ashutosh Bapat
Assignee: Ashutosh Bapat
Fix For: 4.0.0
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.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)