[
https://issues.apache.org/jira/browse/HIVE-21462?focusedWorklogId=233288&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-233288
]
ASF GitHub Bot logged work on HIVE-21462:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 26/Apr/19 06:32
Start Date: 26/Apr/19 06:32
Worklog Time Spent: 10m
Work Description: ashutosh-bapat commented on issue #573: HIVE-21462 :
Upgrading SQL server backed metastore when changing datatype of a column with
constraints
URL: https://github.com/apache/hive/pull/573#issuecomment-486942713
Committed upstream.
----------------------------------------------------------------
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:
us...@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 233288)
Time Spent: 20m (was: 10m)
Remaining Estimate: 23h 40m (was: 23h 50m)
> 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: 20m
> Remaining Estimate: 23h 40m
>
> 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)
