[
https://issues.apache.org/jira/browse/HIVE-23211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17135958#comment-17135958
]
Aasha Medhi commented on HIVE-23211:
------------------------------------
[~b.maidics][~szita] Facing the error :
{code:java}
138/142 ALTER TABLE TXN_COMPONENTS ALTER COLUMN TC_TXNID bigint NOT NULL;
Error: The index 'TC_TXNID_INDEX' is dependent on column 'TC_TXNID'.
(state=S0001,code=5074)
Aborting command set because "force" is false and command failed: "ALTER TABLE
TXN_COMPONENTS ALTER COLUMN TC_TXNID bigint NOT NULL;"
[ERROR] 2020-06-15 19:39:17.112 [main] MetastoreSchemaTool - Upgrade FAILED!
Metastore state would be inconsistent !!
U
{code}
Will be resolved as part of HIVE-23697
> Fix metastore schema differences between init scripts, and upgrade scripts
> --------------------------------------------------------------------------
>
> Key: HIVE-23211
> URL: https://issues.apache.org/jira/browse/HIVE-23211
> Project: Hive
> Issue Type: Bug
> Components: Standalone Metastore
> Reporter: Barnabas Maidics
> Assignee: Barnabas Maidics
> Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-23211.1.patch, HIVE-23211.2.patch,
> HIVE-23211.3.patch
>
>
> There are some differences (character encoding, defaults etc..) in metastore
> schema if we initialize using the init scripts, or upgrade using the upgrade
> scripts. The schema should be identical.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
