Rebuilding Materialized View does not work, saying there is another process re-building the MV.
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"?

