[
https://issues.apache.org/jira/browse/HIVE-28416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17888194#comment-17888194
]
Krisztian Kasa commented on HIVE-28416:
---------------------------------------
[~Dayakar]
Could you please replace the jira summary to something more specific?
"Hive materialized views rebuild issue." is too generic it can be many things.
> Hive materialized views rebuild issue.
> --------------------------------------
>
> 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)