[
https://issues.apache.org/jira/browse/HIVE-25551?focusedWorklogId=654659&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-654659
]
ASF GitHub Bot logged work on HIVE-25551:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 23/Sep/21 18:14
Start Date: 23/Sep/21 18:14
Worklog Time Spent: 10m
Work Description: nrg4878 opened a new pull request #2671:
URL: https://github.com/apache/hive/pull/2671
### What changes were proposed in this pull request?
<!--
Please clarify what changes you are proposing. The purpose of this section
is to outline the changes and how this PR fixes the issue.
If possible, please consider writing useful notes for better and faster
reviews in your PR. See the examples below.
1. If you refactor some codes with changing classes, showing the class
hierarchy will help reviewers.
2. If you fix some SQL features, you can provide some references of other
DBMSes.
3. If there is design documentation, please add the link.
4. If there is a discussion in the mailing list, please add the link.
-->
### Why are the changes needed?
Hive schema for 4.0 for SQL Server does not work.
### Does this PR introduce _any_ user-facing change?
No
### How was this patch tested?
Unit test
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 654659)
Remaining Estimate: 0h
Time Spent: 10m
> Fix Schema upgrade sql for mssql
> --------------------------------
>
> Key: HIVE-25551
> URL: https://issues.apache.org/jira/browse/HIVE-25551
> Project: Hive
> Issue Type: Bug
> Reporter: Ayush Saxena
> Assignee: Ayush Saxena
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> The schema upgrade is failing with:
> {noformat}
> 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 ***
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
