[jira] [Commented] (HIVE-28416) Hive materialized views rebuild issue.

["Krisztian Kasa (Jira)" <ji...@apache.org>]

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