Cloudera Community
RobVi
user rank
New Contributor

Re: Rebuilding Materialized View does not work, sa...

by New Contributor in Support Questions
‎02-08-2023 04:58 AM
‎02-08-2023 04:58 AM
Hi @Shmoo , Thank you for the suggestion. This works! The MV can be rebuilt after manually deleting the stale locks. However, the next interesting question would be why do we get the stale lock? If we know why, we could prevent this from happening again, as an access to hive metastore is not something that we want to make available to all users. ... View more

Rebuilding Materialized View does not work, saying...

by New Contributor in Support Questions
‎01-26-2023 11:38 PM
‎01-26-2023 11:38 PM
Hi Team,   I am trying to re-build my materialized view (ALTER MATERIALIZED VIEW <db>.<table> REBUILD;). However, I got an error message saying that there is another process re-building the MV. Error message: SQL Error [40000] [42000]: Error while compiling statement: FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: Another process is rebuilding the materialized view I tried to check if there is any write lock on the MV or the table, however there is none. I also tried to re-build the MV, but then I got the same error again when I tried to rebuild. Any idea why this is happening or how to check the "another process"? ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎04-25-2023 11:36 AM
Community Statistics
Member Since ‎01-26-2023 11:29 PM
Last Visited ‎04-25-2023 11:36 AM
Posts 2