[
https://issues.apache.org/jira/browse/HIVE-28436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Indhumathi Muthumurugesh updated HIVE-28436:
--------------------------------------------
Description: (was: 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
)
> Incorrect syntax in Hive schema file for table MIN_HISTORY_LEVEL
> ----------------------------------------------------------------
>
> 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
> Fix For: 4.1.0
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
