You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Ashutosh Bapat (JIRA)" <ji...@apache.org> on 2019/03/18 04:46:00 UTC

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

     [ https://issues.apache.org/jira/browse/HIVE-21462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashutosh Bapat reassigned HIVE-21462:
-------------------------------------


> 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
>            Priority: Major
>             Fix For: 4.0.0
>
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> 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)