[HIVE-20820] MV partition on clause position

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• 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: 26/Oct/18 20:04
• Updated: 27/Feb/24 22:23
• Resolved: 29/Oct/18 22:48

Description

It should obey the following syntax as per https://cwiki.apache.org/confluence/display/Hive/Materialized+views :

CREATE MATERIALIZED VIEW [IF NOT EXISTS] [db_name.]materialized_view_name
  [DISABLE REWRITE]
  [COMMENT materialized_view_comment]
  [PARTITIONED ON (col_name, ...)]
  [
    [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
<query>;

Currently it is positioned just before TBLPROPERTIES.