[ https://issues.apache.org/jira/browse/HIVE-26037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17506562#comment-17506562 ]
Stamatis Zampetakis commented on HIVE-26037: -------------------------------------------- Hi [~rahulp], it seems you are using an HDP/CDP release of Hive and not an Apache one. This JIRA instance is only for the Apache project. Please contact the company's support for getting help with this. > 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)