[HIVE-18842] CLUSTERED ON/DISTRIBUTED ON+SORTED ON support for materialized views

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Materialized views
• Labels: pull-request-available todoc4.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 02/Mar/18 00:02
• Updated: 27/Feb/24 22:24
• Resolved: 10/Jul/19 17:18

Description

We should support defining a CLUSTERED ON/DISTRIBUTED ON+SORTED ON specification for materialized views.

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, ...)]
  [CLUSTERED ON (col_name, ...) | DISTRIBUTED ON (col_name, ...) SORTED 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 related to: HIVE-21945 Enable sorted dynamic partitioning optimization for materialized views with custom data organization
• is related to: HIVE-21946 Consider data organization of a materialized view in transparent rewriting
• is related to: HIVE-21953 Enable CLUSTERED ON/DISTRIBUTED ON+SORTED ON in incremental rebuild of materialized views
• relates to: HIVE-14493 Partitioning support for materialized views
• links to: GitHub Pull Request #696