Manage rewriting of a query
You can use a Hive query to stop or start the optimizer from rewriting a query based on a materialized view, and as administrator, you can globally enable or disable rewriting of all queries based on materialized views.
By default, the optimizer can rewrite a query based on a materialized view. If you want a query executed without regard to a materialized view, for example to measure the execution time difference, you can disable rewriting and then enable it again.
Disable rewriting of a query based on a materialized view named mv1 in the
ALTER MATERIALIZED VIEW default.mv1 DISABLE REWRITE;
Enable rewriting of a query based on materialized view mv1.
ALTER MATERIALIZED VIEW default.mv1 ENABLE REWRITE;
Globally disable rewriting of queries based on materialized views by setting a