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)
