Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The rewriting algorithm can be enabled and disabled globally using the hive.materializedview.rewriting configuration property and hive.materializedview.rewriting.sql configuration properties (default value is is true). In addition, users can selectively enable/disable materialized views for rewriting. Recall that, by default, materialized views are enabled for rewriting at creation time. To alter that behavior, the following statement can be used:

Code Block
sql
sql
ALTER MATERIALIZED VIEW [db_name.]materialized_view_name ENABLE|DISABLE REWRITE;

...