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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.1.0
• Labels: pull-request-available
• Assignee: Dayakar M
• Reporter: Dayakar M
• Created: 29/Jul/24 12:32
• Updated: 16/Oct/24 09:27
• Resolved: 16/Oct/24 09:27

Description

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

Issue Links

• links to: GitHub Pull Request #5484