[
https://issues.apache.org/jira/browse/HIVE-28416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17890012#comment-17890012
]
Krisztian Kasa commented on HIVE-28416:
---------------------------------------
Merged to master. Thanks [~Dayakar] for the patch and [~InvisibleProgrammer],
[~difin], [~zratkai] for the review.
> 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)
