You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Stamatis Zampetakis (Jira)" <ji...@apache.org> on 2022/03/14 21:13:00 UTC
[jira] [Resolved] (HIVE-26037) Data type mismatch in metastore upgrade for mysql upgrade-3.1.2000-to-3.1.3000.mysql.sql
[ https://issues.apache.org/jira/browse/HIVE-26037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stamatis Zampetakis resolved HIVE-26037.
----------------------------------------
Resolution: Invalid
> Data type mismatch in metastore upgrade for mysql upgrade-3.1.2000-to-3.1.3000.mysql.sql
> ----------------------------------------------------------------------------------------
>
> Key: HIVE-26037
> URL: https://issues.apache.org/jira/browse/HIVE-26037
> Project: Hive
> Issue Type: Bug
> Reporter: Rahul Pathak
> Priority: Major
>
> Below error was noticed while doing upgrade of hive metadata using mysql setup
> {noformat}
> Referencing column 'ACTIVE_EXECUTION_ID' and referenced column 'SCHEDULED_EXECUTION_ID' in foreign key constraint 'SCHEDULED_EXECUTIONS_SCHQ_ACTIVE' are incompatible.{noformat}
> I can see below inconsistencies.
> {code:java}
> upgrade-3.1.2000-to-3.1.3000.mysql.sql: SCHEDULED_EXECUTION_ID BIGINT NOT NULL{code}
> {code:java}
> upgrade-3.1.3000.7.1.0.0-to-3.1.3000.7.1.1.0.mysql.sql:ALTER TABLE SCHEDULED_QUERIES ADD COLUMN ACTIVE_EXECUTION_ID INTEGER ;{code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)