[HIVE-14493] Partitioning support for materialized views

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 3.2.0, 4.0.0-alpha-1
• Component/s: Materialized views
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 09/Aug/16 17:32
• Updated: 27/Feb/24 22:23
• Resolved: 01/Aug/18 20:03

Description

We should support defining a partitioning specification for materialized views and that the results of the materialized view evaluation are stored meeting the partitioning spec.

The syntax should be extended as follows:

CREATE MATERIALIZED VIEW [IF NOT EXISTS] [db_name.]materialized_view_name
  [COMMENT materialized_view_comment]
  [PARTITIONED ON (col_name, ...)] -- NEW!
  [
   [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 blocked by: HIVE-20241 Support partitioning spec in CTAS statements
• is related to: HIVE-18842 CLUSTERED ON/DISTRIBUTED ON+SORTED ON support for materialized views
• is related to: HIVE-20314 Include partition pruning in materialized view rewriting
• links to: RB link