[
https://issues.apache.org/jira/browse/HIVE-28436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Indhumathi Muthumurugesh updated HIVE-28436:
--------------------------------------------
Description:
1. *Upgrade Order Hive file has incorrect version info:*
Upgrade script upgrade-3.1.0-to-4.0.0-alpha-1.hive.hive.sql
org.apache.hadoop.hive.metastore.HiveMetaException: Upgrade FAILED! Metastore
state would be inconsistent !!
Underlying cause: java.io.FileNotFoundException :
hive/scripts/metastore/upgrade/hive/upgrade-3.1.0-to-4.0.0-alpha-1.hive.hive.sql
(No such file or directory)
Use --verbose for detailed stacktrace.
2. *upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.hive.sql,
upgrade-4.0.0-alpha-2-to-4.0.0-beta-1.hive.sql and
upgrade-4.0.0-beta-1-to-4.0.0.hive.sql have not upgraded version table info.*
Last update to VERSION table in upgrade-3.1.0-to-4.0.0-alpha-1.hive.sql
```
DROP TABLE IF EXISTS `VERSION`;
CREATE OR REPLACE VIEW `VERSION` AS SELECT 1 AS `VER_ID`, '4.0.0-alpha-1' AS
`SCHEMA_VERSION`,
'Hive release version 4.0.0-alpha-1' AS `VERSION_COMMENT`;
```
3. *Syntax error in Tables*
MIN_HISTORY_LEVEL,
VIEW- COMPACTIONS
> Upgrade SYS DB after 4.0.0-alpha-1 version is broken
> -----------------------------------------------------
>
> Key: HIVE-28436
> URL: https://issues.apache.org/jira/browse/HIVE-28436
> Project: Hive
> Issue Type: Bug
> Reporter: Indhumathi Muthumurugesh
> Assignee: Indhumathi Muthumurugesh
> Priority: Major
>
> 1. *Upgrade Order Hive file has incorrect version info:*
> Upgrade script upgrade-3.1.0-to-4.0.0-alpha-1.hive.hive.sql
> org.apache.hadoop.hive.metastore.HiveMetaException: Upgrade FAILED! Metastore
> state would be inconsistent !!
> Underlying cause: java.io.FileNotFoundException :
> hive/scripts/metastore/upgrade/hive/upgrade-3.1.0-to-4.0.0-alpha-1.hive.hive.sql
> (No such file or directory)
> Use --verbose for detailed stacktrace.
> 2. *upgrade-4.0.0-alpha-1-to-4.0.0-alpha-2.hive.sql,
> upgrade-4.0.0-alpha-2-to-4.0.0-beta-1.hive.sql and
> upgrade-4.0.0-beta-1-to-4.0.0.hive.sql have not upgraded version table info.*
> Last update to VERSION table in upgrade-3.1.0-to-4.0.0-alpha-1.hive.sql
> ```
> DROP TABLE IF EXISTS `VERSION`;
> CREATE OR REPLACE VIEW `VERSION` AS SELECT 1 AS `VER_ID`, '4.0.0-alpha-1' AS
> `SCHEMA_VERSION`,
> 'Hive release version 4.0.0-alpha-1' AS `VERSION_COMMENT`;
> ```
> 3. *Syntax error in Tables*
> MIN_HISTORY_LEVEL,
> VIEW- COMPACTIONS
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
