[jira] [Updated] (HIVE-28416) Another process is rebuilding the materialized view is thrown for subsequent MV rebuilds when the current MV rebuild is aborted for the same MV.

["Dayakar M (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-28416?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dayakar M updated HIVE-28416:
-----------------------------
    Summary: Another process is rebuilding the materialized view is thrown for subsequent MV rebuilds when the current MV rebuild is aborted for the same MV.  (was: Hive materialized views rebuild issue.)

> Another process is rebuilding the materialized view is thrown for subsequent MV rebuilds when the current MV rebuild is aborted for the same MV.
> ------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-28416
>                 URL: https://issues.apache.org/jira/browse/HIVE-28416
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Dayakar M
>            Assignee: Dayakar M
>            Priority: Major
>              Labels: pull-request-available
>
> Hive materialized views rebuild issue:
> Abruptly killing the current Materialized View Rebuild command results in not deleting the LOCK entry in the backend metastore DB table 'materialization_rebuild_locks'. With this next time onwards the Materialized View Rebuild command will fail for that Materialied View.
> ALTER MATERIALIZED VIEW view_name REBUILD;
>  
> =====
> Error: Error while compiling statement: FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: Another process is rebuilding the materialized
> view view_name (state=42000,code=40000)
> =====



--
This message was sent by Atlassian Jira
(v8.20.10#820010)