[
https://issues.apache.org/jira/browse/HIVE-28436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Indhumathi Muthumurugesh updated HIVE-28436:
--------------------------------------------
Summary: Incorrect syntax in Hive schema file for table MIN_HISTORY_LEVEL
(was: Incorrect syntax in Hive schema file for table )
> 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
>
>
> 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)
