[HIVE-25551] Schema upgrade for MSSQL fails when adding TYPE column in DBS table

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Assignee: Ayush Saxena
• Reporter: Ayush Saxena
• Created: 23/Sep/21 13:06
• Updated: 17/Nov/22 08:47
• Resolved: 27/Sep/21 13:13

Description

The schema upgrade is failing with:

      ALTER TABLE "DBS" ADD "TYPE" nvarchar(32) DEFAULT "NATIVE" NOT NULL;
Error: The name "NATIVE" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. (state=S0001,code=128)
Aborting command set because "force" is false and command failed: "ALTER TABLE "DBS" ADD "TYPE" nvarchar(32) DEFAULT "NATIVE" NOT NULL;"
[ERROR] 2021-09-23 18:34:34.917 [main] MetastoreSchemaTool - Upgrade FAILED! Metastore state would be inconsistent !!
Upgrade FAILED! Metastore state would be inconsistent !!
[ERROR] 2021-09-23 18:34:34.917 [main] MetastoreSchemaTool - Underlying cause: java.io.IOException : Schema script failed, errorcode OTHER
Underlying cause: java.io.IOException : Schema script failed, errorcode OTHER
[ERROR] 2021-09-23 18:34:34.917 [main] MetastoreSchemaTool - Use --verbose for detailed stacktrace.
Use --verbose for detailed stacktrace.
[ERROR] 2021-09-23 18:34:34.917 [main] MetastoreSchemaTool - *** schemaTool failed ***

Issue Links

• is broken by: HIVE-24451 Add schema changes for MSSQL
• links to: Github PR #2669
• links to: GitHub Pull Request #2669
• links to: GitHub Pull Request #2671