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] [Work logged] (HIVE-21462) Upgrading SQL server backed
metastore when changing data type of a column with constraints
[ https://issues.apache.org/jira/browse/HIVE-21462?focusedWorklogId=214659&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-214659 ]
ASF GitHub Bot logged work on HIVE-21462:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 18/Mar/19 09:40
Start Date: 18/Mar/19 09:40
Worklog Time Spent: 10m
Work Description: ashutosh-bapat commented on pull request #573: HIVE-21462 : Upgrading SQL server backed metastore when changing datatype of a column with constraints
URL: https://github.com/apache/hive/pull/573
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 214659)
Time Spent: 10m
Remaining Estimate: 23h 50m (was: 24h)
> 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
> 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)