[ https://issues.apache.org/jira/browse/HIVE-21404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16801931#comment-16801931 ]
Ashutosh Bapat commented on HIVE-21404: --------------------------------------- Thanks [~dlavati-hw] for addressing my comment. The changes look good to me. +1. > MSSQL upgrade script alters the wrong column > -------------------------------------------- > > Key: HIVE-21404 > URL: https://issues.apache.org/jira/browse/HIVE-21404 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 3.2.0 > Reporter: David Lavati > Assignee: David Lavati > Priority: Major > Labels: pull-request-available > Fix For: 3.2.0 > > Attachments: HIVE-21404.1.patch, HIVE-21404.2.patch > > Time Spent: 10m > Remaining Estimate: 0h > > HIVE-20221 changes PARTITION_PARAMS, so the following command is modifying > the wrong table: > {{ALTER TABLE "SERDE_PARAMS" ALTER COLUMN "PARAM_VALUE" nvarchar(MAX);}} > https://github.com/apache/hive/blob/d3b036920acde7bb04840697eb13038103b062b4/standalone-metastore/metastore-server/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql#L21 -- This message was sent by Atlassian JIRA (v7.6.3#76005)