[jira] [Created] (HIVE-26037) Data type mismatch in metastore upgrade for mysql upgrade-3.1.2000-to-3.1.3000.mysql.sql

["Rahul Pathak (Jira)" <ji...@apache.org>]

Rahul Pathak created HIVE-26037:
-----------------------------------

             Summary: 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


Below error was notice while doing upgrade of hive metadata using mysql setup

Referencing column 'ACTIVE_EXECUTION_ID' and referenced column 'SCHEDULED_EXECUTION_ID' in foreign key constraint 'SCHEDULED_EXECUTIONS_SCHQ_ACTIVE' are incompatible.

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)