[
https://issues.apache.org/jira/browse/HIVE-23392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17136443#comment-17136443
]
Aasha Medhi commented on HIVE-23392:
------------------------------------
Issue in the mysql upgrade script.
{code:java}
WARNING: Unable to create a system terminal, creating a dumb terminal (enable
debug logging for more information)
Warning: You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'COLUMN NTXN_NEXT TO TXN_LOCK' at line 1 (state=42000,code=1064)
Error: You have an error in your SQL syntax; check the manual that corresponds
to your MariaDB server version for the right syntax to use near 'COLUMN
NTXN_NEXT TO TXN_LOCK' at line 1 (state=42000,code=1064)
{code}
Fixing it in HIVE-23697
> Metastore upgrade script TXN_LOCK_TBL rename inconsistency
> ----------------------------------------------------------
>
> Key: HIVE-23392
> URL: https://issues.apache.org/jira/browse/HIVE-23392
> Project: Hive
> Issue Type: Bug
> Reporter: Peter Varga
> Assignee: Peter Varga
> Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-23392.1.patch
>
>
> HIVE-23048 introduced a bug in the metastore upgrade scripts, by not renaming
> correctly the columns in TXN_LOCK_TBL
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
