[HIVE-14497] Fine control for using materialized views in rewriting

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.3.0
• Component/s: Materialized views
• Labels: TODOC2.3
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 09/Aug/16 18:26
• Updated: 27/Feb/24 22:23
• Resolved: 16/Dec/16 13:59

Description

Follow-up of HIVE-14495. Since the number of materialized views in the system might grow very large, and query rewriting using materialized views might be very expensive, we need to include a mechanism to enable/disable materialized views for query rewriting.

Thus, we should extend the CREATE MATERIALIZED VIEW statement as follows:

CREATE MATERIALIZED VIEW [IF NOT EXISTS] [db_name.]materialized_view_name
  [BUILD DEFERRED]
  [ENABLE REWRITE] -- NEW!
  [COMMENT materialized_view_comment]
  [
   [ROW FORMAT row_format] 
   [STORED AS file_format]
     | STORED BY 'storage.handler.class.name' [WITH SERDEPROPERTIES (...)]
  ]
  [LOCATION hdfs_path]
  [TBLPROPERTIES (property_name=property_value, ...)]
  AS select_statement;

Issue Links

• is part of: HIVE-14496 Enable Calcite rewriting with materialized views