[
https://issues.apache.org/jira/browse/HIVE-26037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rahul Pathak updated HIVE-26037:
--------------------------------
Description:
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}
was:
Below error was noticed 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}
> 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)
