You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Indhumathi Muthumurugesh (Jira)" <ji...@apache.org> on 2024/08/05 19:20:00 UTC

[jira] [Updated] (HIVE-28436) Incorrect syntax in Hive schema file for table MIN_HISTORY_LEVEL

     [ 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)