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

Posted to issues@hive.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2019/03/18 09:41:00 UTC

[jira] [Updated] (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 ]

ASF GitHub Bot updated HIVE-21462:
----------------------------------
    Labels: pull-request-available  (was: )

> 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
>              Labels: pull-request-available
>             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)