hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Dai (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-21462) Upgrading SQL server backed metastore when changing data type of a column with constraints
Date Fri, 22 Mar 2019 06:34:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-21462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16798754#comment-16798754
] 

Daniel Dai commented on HIVE-21462:
-----------------------------------

+1 for 02.patch.

> 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
>
>         Attachments: HIVE-21462.01.patch, HIVE-21462.02.patch
>
>   Original Estimate: 24h
>          Time Spent: 10m
>  Remaining Estimate: 23h 50m
>
> 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)

Mime
View raw message